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: 
qlikviewforum
Creator II
Creator II

Help in aggr function!

Hi,

For one of the selections in the UI the below expression throws two values. How this is possible. Please explain! I'm not able to understand it.

aggr(  if($(vXYZ)  >  $(vABC),     

      (pow(10,floor(LOG10($(vXYZ))))),     

      (pow(10,floor(LOG10($(vABC))))))

      ,Business,Business_Unit)

1 Reply
lironbaram
Partner - Master III
Partner - Master III

this expression

calculate the result for each unique instance of Business and Business_Unit

and create a list of values for each unique value

so you should get a result for each unique instance