Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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