topic Dimension field change in PivotTable with macro in QlikView

Dimension field change in PivotTable with macro

azimabadi — Tue, 08 May 2012 13:15:15 GMT

Hi all,

i have a pivottable, and it has two dimensions. i need two change the field defined in second dimension. I know that it's possible to use RemoveDimension and then AddDimension, but for some reasons i need to keep the dimension and only change the field name in defination. Do you think that it is possible?

i will appreciate any help.

Best Regards

Peyman

Dimension field change in PivotTable with macro

Anonymous — Tue, 08 May 2012 13:18:57 GMT

use cyclic groups

Re: Dimension field change in PivotTable with macro

Tue, 08 May 2012 13:52:08 GMT

Hi,

I think the field name we can't chang.but you can achieve your requirement by adding and removing the second dimension.

Please check the attached file.

Hope it helps you.

Regards

......

Dimension field change in PivotTable with macro

jonathandienst — Tue, 08 May 2012 16:09:25 GMT

I agree with the previous post. Cyclics are almost always better than macros.

Regards

Jonathan

Dimension field change in PivotTable with macro

azimabadi — Wed, 09 May 2012 13:23:41 GMT

Thank you all,

"Rav" you are right and this is what i have done in my project. but consider i have 3 dimension and i need to change 2nd, with this method i need to delete 2 and 3, and then add new 2nd and then the same 3th.

i know how to use the groups, but in this special case i can't use them.

Best Regards

Peyman

Re: Dimension field change in PivotTable with macro

Wed, 09 May 2012 13:52:59 GMT

Hi,

Please check the attached file may be it will help for some more extent.

based on the variable change the trigger will do enabling or disabling the particular number of expressions specified in macro.

Regards

.......