topic Re: conditional display chart problem in QlikView

conditional display chart problem

kostiskampouris — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

As the tittle says I want to display a pivot table only if one date from the date listbox is selected.

I searched in qlikcomunity and I found that the solution is the below.

I use a variable Showchart with the expression count(date)

And in the chart(pivot table) properties in the layout tab->Show->Conditional I wrote Showchart=1 .

This doesn't work.

Can anyone suggest why ?

Re: conditional display chart problem

avkeep01 — Tue, 12 Dec 2017 10:20:51 GMT

Hi Kostis,

you probably need $(Showchart) = 1 instead of Showchart is 1. When using the $-sign, the variable will be calculated and will give the result you need.

Re: conditional display chart problem

devarasu07 — Tue, 12 Dec 2017 10:23:49 GMT

Hi,

Try like this, refer to the attached sample. tks

if(GetSelectedCount(YearMonth)=0,0,1) // update your field instead of yearmonth

for your case

if(GetSelectedCount(Date)=0,0,1)

Re: conditional display chart problem

kostiskampouris — Tue, 12 Dec 2017 10:27:39 GMT

Hello A.M van Keep,

Thank you for your responce.

Unfortunatelly $(Showchart) = 1 doesn't work either.

Re: conditional display chart problem

Clever_Anjos — Tue, 12 Dec 2017 10:30:11 GMT

Please try with count(distinct date)

Re: conditional display chart problem

Anil_Babu_Samineni — Tue, 12 Dec 2017 10:31:46 GMT

If you have more than 1 counts it won't effect for all rows. I believe DISTINCT keyword is the trick

Re: conditional display chart problem

tresB — Tue, 12 Dec 2017 10:39:22 GMT

Try writing this expression directly as the conditional expression -> =GetSelectedCount(date)=1

Re: conditional display chart problem

devarasu07 — Tue, 12 Dec 2017 10:42:32 GMT

Hi,

have u tried my suggestion? still issue?

if(GetSelectedCount(Date)=0,0,1)

Re: conditional display chart problem

Michiel_QV_Fan — Tue, 12 Dec 2017 10:49:03 GMT

In the chart properties under layout add to Show the following statement: GetPossibleCount(date) = 1

Re: conditional display chart problem

kostiskampouris — Tue, 12 Dec 2017 12:16:06 GMT

Hi,thank you for your answer ,yes I tried it.It didnt work

Re: conditional display chart problem

devarasu07 — Tue, 12 Dec 2017 12:26:40 GMT

Hi,

Can you share your mock with issue. we will check and help u. tks

Re: conditional display chart problem

kostiskampouris — Tue, 12 Dec 2017 12:38:21 GMT

Re: conditional display chart problem

Hello, Devarasu R unfortunatelly I can't upload any sample.

I have 2 files : One with many sheets and data from different views and one with only one sheet and the data from only one view.

The sheet is in the 2nd qlikview file is exact same as one of the sheets in the 1st file.

All the suggetions above worked fine for the 2nd file but they dont work for the first.

The date field is common all the sheets.Is it possible that linked tables through the date field create the problem ?

Re: conditional display chart problem

Michiel_QV_Fan — Wed, 13 Dec 2017 08:42:52 GMT

Are you using a master calendar?

Re: conditional display chart problem

kostiskampouris — Wed, 13 Dec 2017 08:45:07 GMT

Yes