Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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
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)
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.
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