Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
qlikviewforum
Creator II
Creator II
‎2014-04-07 08:27 AM

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)

244 Views
0 Likes
1 Reply
lironbaram
Partner - Master III
Partner - Master III
‎2014-04-07 08:42 AM

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

153 Views
0 Likes