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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
varunreddy
Creator III
Creator III

How to restrict the filter that is being used as the aggregation

Hi All,

I am trying to count number of issues aggregated by Name. I want my report to ignore the selections made by Name.

Can anyone help me with this?

Expression Used:

Aggr(count({<Name>}Id),Name)

Thanks in advance!

1 Reply
sunny_talwar

Where are you using this? May be this

Count({<Name}>} Id)

or

Only({<Name>} Aggr(Count({<Name>} Id), Name))

If the above is used a calculated dimension, then you need to ignore selection in your expression