topic Re: Always select one in pivot in qliksense in App Development

Always select one in pivot in qliksense

Anonymous — Wed, 24 Jan 2018 13:31:26 GMT

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 — Thu, 01 Feb 2018 16:55:02 GMT

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

Anonymous — Fri, 02 Feb 2018 07:05:47 GMT

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 — Fri, 02 Feb 2018 07:57:32 GMT

Hi,

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

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

Regards,