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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikSensor
Partner - Creator
Partner - Creator

Showing only certain entries in a table

Hi,

I have a dimension called project. Another calculated field shows the average quality level of each project. 

I want to show in a table those projects which have the best average quality level. The best project can be just one project or several project which share the same (best) quality level.

How can I do this?

This statement lists the average quality level:

Avg ({<[Initial Quality Level]-={0}>}[Initial Quality Level])

This statement finds the maximum:

Max(all aggr(Avg ({<[Initial Quality Level]-={0}>}[Initial Quality Level]), [Initial Quality Level]))

And this formula shows in the table for each project whether it has the maximum level or not

Avg ({<[Initial Quality Level]-={0}>}[Initial Quality Level]) = Max(all aggr(Avg ({<[Initial Quality Level]-={0}>}[Initial Quality Level]), [Initial Quality Level]))

 

But I don't know how I can filter the project dimension with this formula. Any help?

0 Replies