topic Dynamic Columns in Qlikview report - what goes wrong in QlikView

Dynamic Columns in Qlikview report - what goes wrong

Tue, 19 Apr 2011 07:28:43 GMT

Dear Qlikview experts,

Recently I designed a Qlikview report with Dynamic columns in it. (This design comes with the Qlikview Forum expert's support.)

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 experts might be easily to spot out what is wrong.

2061.Dyanmic_Column_QlikVeiw_Report.rar

8838.Question.rar

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

Thanks a lot for your help.

Jim

Re. :Dynamic Columns in Qlikview report - what goes wrong

vincent_ardiet — Tue, 19 Apr 2011 08:54:36 GMT

Hi,

It's amazing, I don't know why it works in your first report. Even if you try to reproduce the table, in the same report, I goes wrong. Crazy.

But, I have a solution, if you modifiy your variables with a formula like this :

=if(isnull(GetFieldSelections([Group1])),'NOCOLUMN',GetFieldSelections([Group1]))

Then, you modify the conditionnal display expression for your dynamic colums like :

=vGroup1<>'NOCOLUMN'

Regards,

Vincent

Re. :Dynamic Columns in Qlikview report - what goes wrong

Wed, 20 Apr 2011 00:56:13 GMT

Hello Vincent,

Thank you for your response, I tested your solution, it works and solved the issued I had.

In our testing we 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 suggestion to show NOCOLUMN if no selection of Group1 stopped this from happening and therefore stopped the duplicate entries on the list object.

I am not sure if this is a bug in QlikView or there is a logical reason for this behavior.

Thanks again.

Jim