Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

sajalgour
New Contributor

Always select one in pivot in qliksense

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?

3 Replies
jsf_fasoli
Contributor II

Re: Always select one in pivot in qliksense

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

sajalgour
New Contributor

Re: Always select one in pivot in qliksense

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
Contributor III

Re: Always select one in pivot in qliksense

Hi,

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

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

Regards,

Community Browser