I am trying to write an aggr expression that calculates taxable income at the account level, but displays it at the city/state level. The rule is that if the sum for a given account is < 0...
...nd process_status has similar values for multiple columns. I want to do a group by (aggressive) function and select the process_status group by process_start_timestamp so that process_status is c...
Hi all,
I have the problem of adding up repeated values in the aggregation in a unique way
Monat
Kat 1
Kat 2
Kat 3
Product ID
Value
Jan
A
C
F
1
22
Jan
A...
I have this Ranking formula that returns—(Dash) when a Top N criteria is unmet. I would like it to leave the cell blank instead of Dash. Please note that the—before AGGR does not solve for it. I j...
Hello Qlik Community,
I was looking at a sample code provided by Qlik for Aggr function. When using the function with no qualifier, the result is being shown in the row highlighted. Looking at t...
...he max for each pair of ID & category and sum these maxima for each ID.
So I would have Aggr(Max(value), ID, Category) and Aggr(Sum(...), ID).
Combining these two expressions into one does not w...
...o i need to use the AGGR function to see the total (a sum of all the 1's) but I can't get it to work.
I have attached a sample, any help would be appreciated.
I have 2 measures, b...
Hi Can anyone explain me how the Aggr() function works with beautiful example with data in different scenarios. B'coz i'm getting confuse on this functionality. I've gone through the r...
Hello
Hope you are fine
Can someone show me how I can use cyclic dimension with aggr() funciton ?
2 Examples for my question :
Exemple 1 : with set analysis
Exemple 2 : with aggr...