Awesome QlikView functions – Dual

• Ctrl + Q + Q to create dummy Data model that comprises of three tables

• If I put together three tables resultant table would be as below

• For explanation sake I’m creating a stacked bar chart with one dimension (Dim1) and three expressions (Sum(Expression1) in similar way others).

• Created above chart in straight forward way but a special requirement came on top of this. In place of summed up values in blocks, percentage (each block in a bar) needs to be displayed.

• To implement this I used Dual function which has unique feature of showing up as both String and Number

• String part I used for percentage calculation and Number part I used for actual aggregation

=Dual(Num((Sum(Expression1)/(Sum(Expression1)+Sum(Expression2)+Sum(Expression3)))*100,’#0.0#’)&’%’,Sum(Expression1))

• One other setting you have to remember for making this work is Number format, it should be expression default.

Loading content issue – 1

Suffixed title with 1 because there are so many root causes for “Loading content” issue. This is my second resolution for the same issue but I named my first post different.

In some companies security restrictions on servers will be very high and that could intersect QlikView servers basic requirement. Pointed out one such thing in below screenshot. Ensure “Log on as a batch job” is enabled for QlikView service account

Qlik Tidbit – 1

Generally if you access Data Sources from Control panel on 64-bit OS machine it will open up 64 bit Odbcad.exe which might not be compatible with 32-bit DBs. So if you want to create DSN for 32-bit DB you can use below path to locate Odbcad32.exe.

%systemdrive%\Windows\SysWoW64

One best example of 32-bit DSN name requirement is for Teradata DB.

QlikView SR upgrade

Below snapshot shows the step that I followed for SR upgrading a single box server environment. Same steps can be followed on multiple box environment also, QV installation program will automatically detect the services installed and upgrade that alone.

Note: Upgraded from QV 11.2 SR 5 to QV 11.2 SR 7

 

 

I didn’t add description since I felt it is self explanatory.

For any clarifications pls. feel free to post your question as comments I will reply asap.