Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Contributor III
Contributor III

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
Contributor III
Contributor III
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
Contributor III
Contributor III
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
Contributor III
Contributor III
Author

Hi Gary,

I have created a variable like 

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