This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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 ?
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.
Try like this, refer to the attached sample. tks
if(GetSelectedCount(YearMonth)=0,0,1) // update your field instead of yearmonth
for your case
Hello A.M van Keep,
Thank you for your responce.
Unfortunatelly $(Showchart) = 1 doesn't work either.
Please try with count(distinct date)
If you have more than 1 counts it won't effect for all rows. I believe DISTINCT keyword is the trick
Try writing this expression directly as the conditional expression -> =GetSelectedCount(date)=1
have u tried my suggestion? still issue?
In the chart properties under layout add to Show the following statement: GetPossibleCount(date) = 1
Hi,thank you for your answer ,yes I tried it.It didnt work