topic Re: Dynamic Dimension selection for a pivot table in QlikView

Dynamic Dimension selection for a pivot table

Wed, 28 Aug 2013 13:47:23 GMT

How can i select one or more dimensions from the list of dimensions , so that those dimensions are updated in the pivot table or a chart.

I tried to use the $Field as a list box and then added it as a dimension of the Pivot table.

But all the measures, dimensions are populated from the list box.

I wanted to restrict the list.

Thanks

Thejo.

Re: Dynamic Dimension selection for a pivot table

Wed, 28 Aug 2013 13:52:53 GMT

Let me make sure I understand what you want to do. I think I do and I'm doing this now.

You want to be able to have a pivot table that will dynamically display dimensions/metrics in it based on what dimensions/metrics the user selects right?

Re: Dynamic Dimension selection for a pivot table

Wed, 28 Aug 2013 13:54:50 GMT

Yes, that's correct?

Re: Dynamic Dimension selection for a pivot table

Wed, 28 Aug 2013 13:57:47 GMT

Ok, this is doable as I'm doing this now. There are quite a few steps in doing this. I'll put together an example QVW to upload/attach so you can see how it's done as just typed out steps/instructions may not be enough.

Re: Dynamic Dimension selection for a pivot table

Wed, 28 Aug 2013 13:59:24 GMT

Sure, thanks a lot.Appreciate your help.

Re: Dynamic Dimension selection for a pivot table

Or — Wed, 28 Aug 2013 14:00:58 GMT

Download a copy of the "What's new in QlikView 11" QVW - there's an example in the Reports sheet. All you have to do is adjust the syntax to match your QVW.

Re: Dynamic Dimension selection for a pivot table

arthur_dom — Wed, 28 Aug 2013 14:03:51 GMT

I used a concat expression and a list o variable to do that.

Please see if it helps.

Re: Re: Dynamic Dimension selection for a pivot table

Wed, 28 Aug 2013 15:30:03 GMT

Here is an example QVW of how I do it. It's not much but you'll get the idea.

I hope this helps.

Re: Dynamic Dimension selection for a pivot table

Thu, 12 Feb 2015 14:24:36 GMT

Hello Richard,

Thank you very much for your example. It has helped me tremendously.

I am using your method of selection with filters on dimension types I use to subgroup my list boxes with an if statement in a field expression with in the container object.

The problem that I am experiencing is when I make a selection in one group and then select another group and make a selection there Qlikview forgets the first selection in the first group and that column disappears from my pivot table.

Is their any way I can have Qlikview "remember" selection between my subgroups?