Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Venkatsj
Contributor III
Contributor III

Set analysis

How to use multiple selections with respect to dimension in the line chart?

For e.g.

Nameworking days
Ramesh2
Vignesh4
Suresh5
Ritika6
Geri8

 

From the above table my dimension will be "Name" where measure is "working days"

How to use dimension with selections? e.g. I need only Ramesh, Suresh,  Geri to be in dimension

Kindly advise, thank you.

2 Replies
GaryGiles
Specialist
Specialist

You could define your dimension as:

Aggr(Only({$<Name={'Ramesh','Suresh','Geri'}>} Name), Name)

Or you could define it in the measure using the same set analysis:

Sum({$<Name={'Ramesh','Suresh','Geri'}>} [working days])

 

Venkatsj
Contributor III
Contributor III
Author

Hi Gary, 

That's really helped, thank you.