Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi,
Can you share your mock with issue. we will check and help u. tks
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 ?
Are you using a master calendar?
Yes