Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

azimabadi
Contributor III

Dimension field change in PivotTable with macro

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

Tags (1)
5 Replies
Highlighted
srikanthsri1
Valued Contributor

Dimension field change in PivotTable with macro

use cyclic groups

Not applicable

Re: Dimension field change in PivotTable with macro

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

......

MVP
MVP

Dimension field change in PivotTable with macro

Hi

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

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
azimabadi
Contributor III

Dimension field change in PivotTable with macro

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

Not applicable

Re: Dimension field change in PivotTable with macro

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

.......