Qlik Community

Qlik Sense Cloud Discussions

Highlighted
prashant2202
New Contributor

Single select filter in Qlik Sense cloud version

I have a requirement where i am putting a filter in my Qlik Sense sheet for selecting a month, out of the possible values from 1 to 12.

Following are the expectations

1. User should be able to select any one value from the filter at a time

2. For any value selected the system should display the values less than or equal to the selected filter value. for e.g. value selected as 7 i.e. 'July', then system should display values from 1 to 7, i.e. January to July

Kindly help out.

1 Solution

Accepted Solutions
Khan_Mohammed
Honored Contributor II

Re: Single select filter in Qlik Sense cloud version

Single select is not yet available in QlikSense cloud.

In enterprise you can use extensions

and for 2nd requirement

you can probably use

SUM({ < Month = {"<=$(=num(Month))"}>} YourMeasureFieldHere)

Month field above is Jan, Feb, Mar etc...

6 Replies
Khan_Mohammed
Honored Contributor II

Re: Single select filter in Qlik Sense cloud version

Single select is not yet available in QlikSense cloud.

In enterprise you can use extensions

and for 2nd requirement

you can probably use

SUM({ < Month = {"<=$(=num(Month))"}>} YourMeasureFieldHere)

Month field above is Jan, Feb, Mar etc...

prashant2202
New Contributor

Re: Single select filter in Qlik Sense cloud version

Hi Shahbaz, This works like a charm. One other issue though.

The other filters still take up the value which is selected in the month filter.

I want those too to consider the less than or equal to month values.

Khan_Mohammed
Honored Contributor II

Re: Single select filter in Qlik Sense cloud version

Sorry can you explain it with an example?

Employee
Employee

Re: Single select filter in Qlik Sense cloud version

Single select IS enabled in qlikcloud now.

You will find the setting here (posting external link to screenshot since it seems I can not upload pictures at the moment);

https://imgur.com/a/Qfe2l8o

BR

Lucke

prashant2202
New Contributor

Re: Single select filter in Qlik Sense cloud version

So let my data have the following 4 columns

1. Month => Ranging from 1 to 12, signifying Jan to Dec. For this i used a list box extension and created a single select filter

2. Sales => Amount in dollars against each transaction

3. Customer Name => Individual customer name fulfilling the transaction. Another filter on the dashboard

I have my measure as display Sum(Sales) for month dimension

Filters present on the dashboard are Month and Customer Name


Now when i select month lets say 6, so as per the formula you gave earlier i implemented a solution where system displayed sum(Sales) for months less than or equal to 6.


However, the other filter Customer Name only gets left with the values for the month = 6 and not <= 6

My requirement is to align the filter too to show the values less than or equal to the value selected in the month filter.


Hope this clarifies.

Khan_Mohammed
Honored Contributor II

Re: Single select filter in Qlik Sense cloud version

It should work regardless of filter selection.

Can you upload a sample app or data?

or maybe try...

SUM({ < Month = {"<=$(=num(Month))"}, [Customer Name]=>} YourMeasureFieldHere)