Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
YG
Contributor III
Contributor III

Qlik Sense - Select only 2 selections from a char Field for a Line chart

Hi Qlikers,

I am having a challenge and I could not find an answer in the Qlik community. Hope you can help me resolve this challenge.

I have a Line Chart,

YG_0-1599617732431.png

Below are the selections I have made,

YG_1-1599617805190.png

However, I want to make sure by default the line chart ONLY select 2 character values from the Field,

Field- Priority

Default selections should be - "1 - Critical","2 - High"

So far I have tried below measure,

=Aggr(ONLY({<Priority={"1 - Critical","2 - High"}>} Priority),Priority)

And I used it at,

YG_2-1599617986419.png

But Line chart does not seems to change and I am not sure,

1. Did the measure I used correct? 

2. Did I use the measure at the correct place in Qlik sense.

I also dont want user to make that decision using Filter as That is not an option in the requirement.

I am new at this hope any one can help? Thanks

 

 

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi 

didn't really understood what you look for , 

do you want to use only those 2 values , or the values should change according to selections

also if you want it in a measure it should look like this 

count({<Priority={"1 - Critical","2 - High"}>} incident) 

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

didn't really understood what you look for , 

do you want to use only those 2 values , or the values should change according to selections

also if you want it in a measure it should look like this 

count({<Priority={"1 - Critical","2 - High"}>} incident) 

YG
Contributor III
Contributor III
Author

Thanks for that  exactly I was looking  for

Answer to be exact :   Count( {<[Priority]={'1 - Critical','2 - High'}>} Incident_Number)