topic Dynamic columns on Qlikview Report in QlikView

Dynamic columns on Qlikview Report

Tue, 12 Apr 2011 07:56:31 GMT

Hello Everyone,

I'm wondering whether anyone can give me some ideas on how to create a Qlikview report which contains dynamical columns.

For example, at beginning, the report is blank, after a Product Category is selected from a list box, then a Product Category column appears on the far left end of the report, later on, Product Name is selected, then a Product Name Column appears on the report next to the Product Category column, now there are two columns on the report, then all the calculated value for the two columns are on the right side of the report. please see the layout picture.

If more Selections are made then more columns will be inserted into the report, and the existing column can be removed by users if it is not in use any more.

It sounds pretty challenging, because normally Qlikview report only has static columns on the report, but I think there must be a way to do it, however currently it is beyond my imagination, does anyone have any suggestions, Thanks a lot in advance.

Jim

Dynamic columns on Qlikview Report

vgutkovsky — Tue, 12 Apr 2011 19:02:56 GMT

This is actually quite simple, but is only possible with the following technique using a Straight Table. Under the Presentation tab, select the Product Category column and then select "Conditional." For the condition, you can use something like getselectedcount([Product Category])>0

Regards,

Dynamic columns on Qlikview Report

Tue, 12 Apr 2011 22:40:02 GMT

Hello Vlad Gutkovsky,

Thank you very much for your kind reply. I will try this method and see how it goes.

Thank you again.

Jim

Dynamic columns on Qlikview Report

Thu, 14 Apr 2011 01:09:27 GMT

Dear Qlikview experts,

Here I have a few problems with my Dynamic Cloumn Report design in QlikView.

Please refer to the following screenshot and my source code.

Problem 1:

How to make the selected name at point 1 to show up in point 2 as Column name, (the points1,2,3 mentioned are marked in red color on the screenshot). At point 2 the current display is the expression at point 3.

Problem 2:

After the three selections are made (marked in Green color at point 1 in the screenshot), all the rows in the report of 'Groups' are messed up due to each selection,such as Apple, Banana, Cherry, has different number of values.

It supposes to be looking like this:

but it is not.

0647.Dyanmic_Column_QlikVeiw_Report.zipSo does any expert have any idea on how to solve the issues I mentioned above, please see my source code,

just download all the things to your desktop. It is a very practical design, I think

I love you experts in the forum as you always come with great ideas to conquer the hard challenges from Qlikview design.

Many thanks in advance.

(Special thanks to

Mr. Vlad Gutkovsky,

Consultant,

Natural Synergies, Inc.

as this design comes from your initial suggestion in my previous post 'Dynamic columns on Qlikview Report' dated on 12/04/2011)

Jim

Dynamic columns on Qlikview Report

vgutkovsky — Thu, 14 Apr 2011 02:45:48 GMT

Problem 1: Set the label of the dimension to: =[Group 1] and the same for the other dimensions

Problem 2: Your data model is causing this problem. All the fields are islands so they are not associated. Therefore, when you put them into the same chart, QV will create every possible combination of them. I hope that makes sense.

Regards,

Dynamic columns on Qlikview Report

Thu, 14 Apr 2011 05:29:11 GMT

Thank you sir,

What you said is correct, as my head was in an absent-minded state these days, I become very dull.

I think I solved the problem, and what you said is really helpful.

I'm testing the new version report now and try to make it a bit better and nicer.

If there are any new issues come out, I will let you know.

Many thinks to you.

Jim

Dynamic columns on Qlikview Report

vgutkovsky — Thu, 14 Apr 2011 14:08:44 GMT

Glad I could help! Please verify correct answers 🙂

Cheers,

Dynamic columns on Qlikview Report

Tue, 19 Apr 2011 00:39:04 GMT

Hello Vlad,

I currently have another issue about the Dynamic Column Qlikview report, it is listed below:

I finalized the report, it works fine (please refer to my source report: Dyanmic_Column_Qlikview_report.rar). but when I tried to build another same one, however it doesn't work properly (please refer to my another source report: Question.rar), and I compared the two, everything looks identical, and I could not figure out where goes wrong.

please have a look at my Qlikview source reports and the screenshot, then your expert might be easily to spot out what is wrong.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/2061.Dyanmic_5F00_Column_5F00_QlikVeiw_5F00_Report.rar:550:0]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/8838.Question.rar:550:0]

I tried hard but still could not find out what is wrong.

Thanks a lot for your help.

Jim

Dynamic columns on Qlikview Report

Tue, 19 Apr 2011 00:41:33 GMT

And the table relations looks alright in each Qlikview report.

Dynamic columns on Qlikview Report

vgutkovsky — Tue, 19 Apr 2011 19:15:58 GMT

Jim,

It's considered bad forum etiquette to not accept correct answers...please verify all correct answers (can verify more than 1).

Re your newest problem, see attached solution.

Regards,

Dynamic columns on Qlikview Report

Tue, 19 Apr 2011 23:58:12 GMT

Hello Vlad,

I verified all your correct answers just now.

Sorry for that delay, because at beginning I didn't know I need to do so, and didn't notice this button.

So in your previous post, you mentioned 'verify answers', I was confused a bit that how to verify correct answer. Now I know it, thank you.

Currently I have problem with opening your replied Qlikview report due to my Qlikview program can not open it. Then I will response to verify answer later.

Thank you again.

Dynamic columns on Qlikview Report

vgutkovsky — Wed, 20 Apr 2011 00:08:31 GMT

Jim,

You will need a license for your QV Desktop to open the application (either a local license or leased from a server).

Regards,

Dynamic columns on Qlikview Report

Wed, 20 Apr 2011 05:38:23 GMT

Hello Vlad,

Thank you for your response, I checked your solution which is a brilliant idea, it works well and solved the issued I had.

Previously while testing in my own Qlikview report, I found when vGroup1=getfieldselections(Group1), if no entry was selected for Group1 then $(vGroup1) as a calculated dimension returned every column name in the model. Your solution stopped this from happening and therefore stopped the duplicate entries on the list object.

Thank you again.

Jim

Re: Dynamic columns on Qlikview Report

Wed, 19 Sep 2012 08:27:55 GMT

Hi,

Is is possible in Pivote table ?

Regards,

Yojas