Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Automatic Button

Hi,

Does anyone know how can I do something automatic in qlikview? It is that

In pivot table, you know there are dimensions hided in + and we expand it all to be able to see each dimension further. My question is is there a way to do it automatically expanded in a simple button instead of doing it manually? Maybe in macro or similar...?

Many thanks in advance,

Cheers

Kezban

12 Replies
Not applicable
Author

Hi Andrew,

I just would like to sum it up  below:

I have 2 sub expand and sub collapse macros. So I will write them down in a action inside the button with run macro section. Right? I hope that should be enough. Becuse ,it works all together it doesnt understand when collpase when to expand. I have good knowledge of excel macros but not the same in qlikview. Then I have doubts on variable:

vChartToExpand : what should i type inside in expression of this variable? You said chart ID 2 buttons. The only thing I am stuck on now.

Many thanks...

Kezban

awhitfield
Partner - Champion
Partner - Champion

No problem Kezban, I a created an example QVW as described above

Not applicable
Author

Hi Andrew,

Thank you a lot for your prompt very helpful responses. I am more than grateful as It helped a lot for my job through the customer. I am like 1 month in qlikview getting into it.

thnks again

Cheers

Kezban