Find this post interesting? Do you like interesting things? Maybe you would like my invention, a connectible candle called a WickBrick! Get one here http://wickbrick.etsy.com/ SET versus LET SET Var1 = 2 * 3 Takes what ever is on the right and places it in the variable as literal text. So Var1 will = 2 [...]
Filed under: Applied IT, Qlikview | Tagged: Qlikview, QlikView Set, QlikView Let, Let, Set | 1 Comment »
Find this post interesting? Do you like interesting things? Maybe you would like my invention, a connectible candle called a WickBrick! Get one here http://wickbrick.etsy.com/ So I was trying hard to get the ZFC to work and I kept on getting “Failed to open document, file not found.” grrr it was absolutely driving me crazy! [...]
Filed under: Applied IT, Qlikview | Tagged: Qlikview, QlikView Zero Foot Print Client, QlikView ZFC | 2 Comments »
So the first question we always ask when a user has a problem is, what is your computer name. You can always go the right click on the mycomputer icon, then properties, the computer name tab, and then read me the name after Full computer name. The cheater way is to tell them hit start, [...]
Filed under: Applied IT | Tagged: Quick Tip | 1 Comment »
Very basic but, never do this Using connection As New SqlConnection(connectionString) Dim command As New SqlCommand(“select * from Customers where city = ‘” + inputCity + “‘”, connection) Instead Private Sub UpdateDemographics(ByVal customerID As Integer, _ ByVal demoXml As String, _ ByVal connectionString As String) ‘ Update the demographics for a store, which is stored [...]
Filed under: Uncategorized | Leave a Comment »
So if you ever need to embed some data, like if you wanted to define a week to quarter relationship, the Inline Data Wizard is the way to go. Click the Inline Wizard button and then type in your data. This will make you something that looks like this LOAD * INLINE [ Month, Quarter [...]
Filed under: Uncategorized | Tagged: Qlikview Enterprise, Qlikview Inline Data | Leave a Comment »
Another common problem. Occurs when associations between three or more tables go around in a circle. If it happens QlikView will give you a warning and find the table with largest amount of records and make it loosely coupled.
Filed under: Uncategorized | Leave a Comment »
Find this post interesting? Do you like interesting things? Maybe you would like my invention, a connectible candle called a WickBrick! Get one here http://wickbrick.etsy.com/ Synthetic keys occur when two or more tables have two or more fields in common. Like if you had an ORDER_DETAILS table that had an Order ID and a ProductID [...]
Filed under: Qlikview | Tagged: Qlikview, qlikview synthetic keys | 1 Comment »
I find that blogging about the learning process is very helpful for me, and hopefully for anyone who is following behind. So I have started a new, from the very beginning blog on learning QlikView. QlikView is amazing, and is very simple to learn yet so very complex. Here is the link Tales from a [...]
Filed under: Uncategorized | Tagged: learning, Qlikview, Qlikview Enterprise, teaching | Leave a Comment »
Tools, edit module Create macro Sub ReloadStuff ActiveDocument.Reload End Sub And then go to settings, document properties, macros tab, OnOpen and then select your ‘ReloadStuff’ Macro
Filed under: Uncategorized | Tagged: Qlikview, qlikview reload on open, qlikview reload onopen | Leave a Comment »
To enable the management interface on either an OpenVPN server or client, add this to the configuration file: management localhost 7505 This tells OpenVPN to listen on TCP port 7505 for management interface clients (port 7505 is an arbitrary choice — you can use any free port). From here: http://openvpn.net/index.php/documentation/howto.html
Filed under: Uncategorized | Tagged: enable management interface, OpenVPN | 1 Comment »
