Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Senor_Dai
Partner - Creator II
Partner - Creator II

Aggregation & Set Analysis within Variable

Hi,

I have two Dimensions :

  1. User
  2. Department
  3. AuditTime

and two Flag fields:

  1. Flag_Today
  2. Flag_Checkout

I have the following variable: 

=Count({<Flag_Checkout={'1'},  Flag_Today={'1'}>}AuditTime) 

Can anyone advise on creating a second variable that shows the highest Count by User .  Eg, vHighestCheckout could show 50 for 'today' 

If I use the following Example Pivot :

Screenshot 2021-11-04 at 14.21.04.png

Id like a variable that contains '11' 

Many thanks for any help

Dai

Labels (1)
  • Other

1 Reply
MayilVahanan

Hi

Try like below

=Max(Aggr(Count({<Flag_Checkout={'1'},  Flag_Today={'1'}>}AuditTime) , User))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.