Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
UserID2626
Partner - Creator III
Partner - Creator III

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

Labels (4)
1 Solution

Accepted Solutions
5 Replies
kalyanamharish
Contributor III
Contributor III

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

tresesco
MVP
MVP

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

UserID2626
Partner - Creator III
Partner - Creator III
Author

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.

 

bismart
Creator
Creator

Create a variable (variable1) as follows;

=concat(GetFieldSelections(Month))

Use this variable in your expression as follows

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

UserID2626
Partner - Creator III
Partner - Creator III
Author