topic Pivot table issue in QlikView

Pivot table issue

Wed, 03 Feb 2016 19:41:10 GMT

I have a Pivot table with Dimensions Manager, customer, Salesperson, City and with Expression Total Sales. This is a Default chart in all the tabs, as per user requirement I have to change the order of the Dimensions like City, Customer, Manager, salesperson.so now without changing the order of previous pivot table I have to show the current requirement using Button.

If I click on the Button the Order of the Dimensions should change automatically within the same pivot table without creating the macro and second pivot table otherwise default pivot table remains same

Thanks

Re: Pivot table issue

swuehl — Wed, 03 Feb 2016 21:30:50 GMT

Why not just drag the dimension columns around as needed by the customer?

Re: Pivot table issue

Wed, 03 Feb 2016 21:48:52 GMT

That Pivot table cant be change it should be remains same when they click on button it has to change as per requirement.

Re: Pivot table issue

swuehl — Wed, 03 Feb 2016 22:17:20 GMT

Maybe I'm missing something, possible solutions are:

a) drag columns (no, you don't want this)

b) Create multiple charts with different dimension order, show / hide conditionally by button (no, you don't want a second chart)

c) Change dimensions by macro (no, you don't want that)

d) last thing I can think of: Create 2 cyclic dimension groups identical with all 4 dimension fields, use these groups, then the user can change the order of dimensions by cycling to appropriate dimension in each column.

Re: Pivot table issue

MarcoWedel — Sat, 06 Feb 2016 00:44:08 GMT

Hi,

one solution might be also:

hope this helps

regards

Marco