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...
...In the rangesum I used this formula: num(Rangesum(aggr(sum(KGS), HACCP)), '#.##0')
In the right column 'wanted' you see what I want to see, so the total is correct, but I want the r...
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...
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...
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...