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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with syntax on line chart to only show scores over 4 AND groups that have a count over 30?

So I have successfully had a line chart where I filtered out all scores that were under 4...and successfully had a pivot chart where I filtered out groups under 30. I am trying to have a line chart where I do both...but I must be screwing things up here, because it is just making the lines disappear even though I know these groups are over 30.

So I am just using the term "Measure" for what I am having counted as being over 4 and "Filter" for what I am using in my filter pane to select what shows up in the line chart.

Num(Count({<Measure = {">=4"}, Filter = {">=30"} >} Measure) /Count({<Filter= {">=30"} >} Measure),'0%')

Thanks for any help anyone can give me!

Jordan

10 Replies
sunny_talwar

Would you be able to provide a sample or sample data to test this?