Always select one in pivot in qliksense

[Anonymous]

Hello Experts,

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.

Any idea?

[Anonymous]

Do you want to see just one year month at a time?

[Anonymous]

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.

[big_dreams]

Hi,

Go to chart Property > Add- ons > Data Handling >Calculated condition >write condition

if(getSelectedCount(Year)=1 and getSelectedCount(Month)=1,1,0)

Regards,