topic Re: Dimension order in the report when we use conditional hide & Show in QlikView

Dimension order in the report when we use conditional hide & Show

chiru_thota — Thu, 24 Oct 2013 17:28:57 GMT

Dear Developers,

We are using Conditional Hide and Show feature for enabling dimensions in our report.It is working fine.

But the Dimension order is always coming in the report dimension order even though I select different order from list box. .

Report Dimension Order :

Report :

My requirement is to get the dimension in list box selected order in to the grid.

For example if I select Dim3 first ,then Dim5 and then Dim1 from Choose Dimension list box.Report should show as below

Is this possible in Qlikview ?

I am also attaching sample application.

Thanks,

Chiru.

Re: Dimension order in the report when we use conditional hide & Show

Anonymous — Thu, 24 Oct 2013 17:53:45 GMT

Chiru,

QlikView "doesn't know" in what order the selections were made. It only "knows" what is selected. That is, the first answer - not possible.

The second answer... It may be possible if create a variable which is controlled by a macro, so each time the selections are made, the values are added to the variable. As a result, the variable contains a list of values in the order they were selected. Next, use it somehow in the chart. If you want to try it - please share the results.

Regards,

Michael