topic Re: Show conditional with variabele in QlikView

Show conditional with variabele

ahamers — Sat, 20 Jan 2018 16:25:58 GMT

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;

Re: Show conditional with variabele

akshaye_c_navale — Sat, 20 Jan 2018 16:40:20 GMT

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

Re: Show conditional with variabele

maxgro — Sat, 20 Jan 2018 20:36:07 GMT

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)

Re: Show conditional with variabele

Peter_Cammaert — Sat, 20 Jan 2018 20:55:01 GMT

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.

Re: Show conditional with variabele

ahamers — Sat, 20 Jan 2018 21:45:53 GMT

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