topic Re: Pivot table in QlikView

Pivot table

brindlogcool — Thu, 12 Apr 2012 14:56:30 GMT

Hi,

In the pivot table , i have 3 dimensions and all are collapsed. Is it possible to trigger an event when user expands one row or multiple rows from the pivot table either from the first or second dimension.But i wanted to know how to know if user expands the dimension or not.

Re: Pivot table

jagan — Thu, 12 Apr 2012 15:04:19 GMT

Hi,

There is no Trigger or Event in qlikview for expansion of pivot table row, but you can know by using Dimensionality().

Check the example. Hope it helps you.

Regards,

Jagan.

Pivot table

brindlogcool — Thu, 12 Apr 2012 20:20:07 GMT

Thanks Jagan it is really useful,

But i want the expanded value to be stored in a variable not as a column in the pivot table.

Pivot table

jagan — Fri, 13 Apr 2012 06:09:34 GMT

Hi,

Can you let me know what is your requirement, what you want to do by storing it in a variable. I think it is not possible. But will try for work around.

Regards,

Jagan.

Pivot table

brindlogcool — Mon, 16 Apr 2012 13:23:52 GMT

Hi Jagan,

Thanks for your response. I have a multibox for a single coulmn for the Pivot table.So if all dimension are collapsed it will be the second column.When the dimension is expanded then it will be thrid column. So i have either keep two multiboxes with show and hide based on the expand and collapse .Or i have move the same multiboxes based on the expand and collapse of the pivot table.