Dynamic columns on Qlikview Report

[#1]

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

[#2]

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.

[vgutkovsky]

Jim,

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

Regards,

[#4]

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

[#5]

Hi,

Is is possible in Pivote table ?

Regards,

Yojas