Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
Contributor II

Multiple selection in set analysis Qlik sense

Hi,

Help me with condition for giving multiple selection in set expression condition.

Image.JPG //This is not working

1 Solution

Accepted Solutions
Highlighted
Contributor II

Re: Multiple selection in set analysis Qlik sense

5 Replies
Highlighted
New Contributor III

Re: Multiple selection in set analysis Qlik sense

Try this
=Aggr(Only({1<Month={"$(=Getfieldselections(Month))"}>}Month),Month)

Highlighted
MVP
MVP

Re: Multiple selection in set analysis Qlik sense

There could be multiple reasons why this is not working. Could you explain your context here? What are you trying to achieve?

Highlighted
Contributor II

Re: Multiple selection in set analysis Qlik sense

My requirement is to display month wise in straight table based on selection of month.

Showing last 6 months or last 3 months from maximum month is working.

But this requirement is like selection of random months; selecting jun & jan should only display jun & jan.

If i select feb,jan & aug respective months alone need to shown.

My measures for table is almost 15, so instead of writing expression on each measure trying to achieve with Dimension condition.

 

Highlighted
Contributor

Re: Multiple selection in set analysis Qlik sense

Create a variable (variable1) as follows;

=concat(GetFieldSelections(Month))

Use this variable in your expression as follows

=sum({<Month={$(variable1)}>}Expression1)

Highlighted
Contributor II

Re: Multiple selection in set analysis Qlik sense