Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ahamers
Contributor
Contributor

Show conditional with variabele

Hello I have several charts on a sheet. If I am leaving the sheet all the charts must disappear from the sheet.

With the conditional show  myVarCH =0

Now I create the trigger when I am leaving the sheet (with all the charts) one chart myVarCH25 is gone.

Queustion: can I get one trigger for all my charts?

for example

myVarCH1 =0;myVarCH2 =0;myVarCH3 =0;myVarCH4 =0;myVarCH5 =0;myVarCH6 =0;

chart_prop.png

sheet_prop.png

4 Replies
akshaye_c_navale

Hey ,

You need to specify conditional show / hide for each charts in Layout tab

But have one question why you want to hide all charts on sheet leave?

Thanks,

Akshay

maxgro
MVP
MVP

the OnLeaveSheet is by sheet

you have to add the trigger for every sheet

to hide all the charts of one sheet you only need one variable in the trigger (myVarAllCH)

every chart can by show/hidden in conditional show  with the same variable (myVarAllCH)

Peter_Cammaert
Partner - Champion III
Partner - Champion III

I was under the impression that if you leave a sheet (and switch to another), all objects on the original sheet (not just the charts) automatically disappear...

If you are worried about invisible objects being recalculated when you change your selections, rest assured: that isn't happening in QlikView.

ahamers
Contributor
Contributor
Author

Extra information:

On sheet A I get several totals from different courses

On sheet B I get the detail-information from each course.

I push a buttom on one course on the total sheet and I want to see the rigth chart (no.25) with the detail information on sheet B.

From sheet A --> activated sheet B | myvarCH25=1

then

From sheet B I go back to sheet A --> myvarCH25=0 | activated sheet A

From sheet B with the detail information I don't want to give in for eache chart this command.

Question:

is there one command to give all the different charts CH01 + CH02 + CH03 .......

the command myvarCHxx=0

or can I give the variabele command on one rule like:

myvarCH01=0 ; myvarCH02=0 ; myvarCH3=0

I'll hope my problem is a little bit clear now