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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator II
Creator II

Filter based on measure not displayed on graph

I have a bar graph as shown below.  The graph displays Name on X axis and Scores on Y axis. I need to display the names only if the name has value for another measure Grades that is not displayed on graph. For example John doesn't have a grade , so John should not appear on the dashboard. Help is appreciated.

jjustingkm_0-1613574915930.png

 

5 Replies
GaryGiles
Specialist
Specialist

@jjustingkm 

You need to use something like this as your dimension:

=aggr(only({$<Grades-={*}>} Name), Name)

jjustingkm
Creator II
Creator II
Author

just wanted to know , can I use Dimension limitation - Exact value then select fx, give Sum(grades) there.

GaryGiles
Specialist
Specialist

Sorry, I'm not sure what your question is.  A little more detail would help.

jjustingkm
Creator II
Creator II
Author

I am talking about this. Here below instead of number if I use the function , in this case sum(grades) , would it give the desired result? I don't think it would work it only compare the number against the metrics displayed on the graph.

 

jjustingkm_0-1613600868202.png

 

jjustingkm
Creator II
Creator II
Author

Hi Gary,

I have created a variable like 

=aggr(only({$<$(vGrade)-={*}>} Name), Name) - but getting null values everywhere.