Is there any way in qliksense to restrict user to select only one value at a time in pivot.
I have a simple pivot table of year and month as two dimension and sales as measure. I want that in pivot only one value should e selected at a time.
Do you want to see just one year month at a time?
Currently user can select any number of month. I want user to be restricted to select only one month at a time in pivot.
Yes I want to show only that month data.
Go to chart Property > Add- ons > Data Handling >Calculated condition >write condition
if(getSelectedCount(Year)=1 and getSelectedCount(Month)=1,1,0)
Retrieving data ...