topic Pivot table expansion question in QlikView

Pivot table expansion question

devans_1 — Tue, 25 Nov 2014 15:24:40 GMT

Hi All,

Is it possible to work out whether a field in a pivot table is expanded or not ? I have 'x' fields in a table and I wish to know whether a particular one of these is expanded or not. I want to pop up a pop up if it is not.

Any help/advice appreciated.

David

Re: Pivot table expansion question

Jason_Michaelides — Tue, 25 Nov 2014 15:28:55 GMT

I'm afraid not. At least not in the main UI. I don't think there is a VB query either.

Could you use Dimensionality() and display something in the chart?

Re: Pivot table expansion question

Tue, 25 Nov 2014 15:57:47 GMT

Agreed, don't think there is an easy way to do this. Only other option I can think of is a custom drill down group and conditional dimensions based on that, so you would expand (i.e show) using the drill which can be readable to pop a message.

Re: Pivot table expansion question

Jason_Michaelides — Wed, 26 Nov 2014 12:26:03 GMT

I've just had an idea....

How about creating a pivot table with (e.g.) 5 dimensions and manually expanding them all once. Make dims 2-5 conditional based on some kind of user action (button to update a variable maybe) and when the user activates them they will be expanded already (I think). You will know when dims are "enabled" which also represents "expanded" so you can pop a message.

Hope this helps,

Jason

Re: Pivot table expansion question

Wed, 26 Nov 2014 13:01:25 GMT

You would need to have the chart fully expanded for that, or users could collapse down in chart and the variable wouldn't be updated, potentially giving the wrong popped message. So you'd need a collapse action along with the expand, sounds good though

Re: Pivot table expansion question

devans_1 — Thu, 27 Nov 2014 07:44:44 GMT

It looks like there may be some possible scope to solve this with some workaround but the short answer to my problem appears to be that it can't be done easily.

Thanks all for these ideas.

Re: Pivot table expansion question

Thu, 27 Nov 2014 08:48:46 GMT

hit the nail on the head there yea

Re: Pivot table expansion question

Jason_Michaelides — Thu, 27 Nov 2014 16:54:29 GMT

Please mark a correct answer to close the thread.