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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ym
Contributor II
Contributor II

Rank, Ignore Dimensions

I try to rank the sales. 

My problem is that my formula does not ignore  the dimensions "Name.Supplier" and "City.Supplier"

If I select a "Name.Supplier, I get the value 0. 

 

Sum({<[Client] = {"=Rank(Sum(Sales))<=10"},Year={$(=GetFieldSelections(Year))},Name.Supplier=, City.Supplier=>}[Sales])

 

What should I change?

 

Labels (1)
0 Replies