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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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

 

 

Labels (2)
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)