conditional display chart problem

[kostiskampouris]

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 ?

[avkeep01]

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.

[devarasu07]

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)

[kostiskampouris]

Hello A.M van Keep,

Thank you for your responce.

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

[Clever_Anjos]

Please try with count(distinct date)

[Anil_Babu_Samineni]

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

[tresesco]

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

[devarasu07]

Hi,

have u tried my suggestion? still issue?

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

[Michiel_QV_Fan]

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

[kostiskampouris]

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