Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
kostiskampouris
Contributor II
Contributor II

conditional display chart problem

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 ?

13 Replies
avkeep01
Partner
Partner

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
Master II
Master II

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)

Capture.JPG

kostiskampouris
Contributor II
Contributor II
Author

Hello A.M van Keep,

Thank you for your responce.

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

Clever_Anjos
Employee
Employee

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tresesco
MVP
MVP

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

devarasu07
Master II
Master II

Hi,

have u tried my suggestion? still issue?

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

michielvandegoo
Specialist
Specialist

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

kostiskampouris
Contributor II
Contributor II
Author

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