topic Aggr Function Qlikview in QlikView

Aggr Function Qlikview

shah_jigesh16 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Working on a piece of expression using AGGR() function.

Expectated Result: Year is dimension and calculate sum of sales using aggr function. But the condition for each row i.e. Year is different

For Ex:1 Aggregate by LOB and verify that if sum >0 then show sum else 0 and then find sum

Year = 2008 condition1 = a

Year = 2009 Condition1 = B

When we try to put that in an expression is only shows for One condition and 0 for all other rows/years.

Any input/ help will or anyone ever faced this situation please help.

Thanks,

sunny_talwar — Thu, 26 Jul 2018 17:09:34 GMT

Would you be able to elaborate with few rows of mocked up data as an example to show what you have?

shah_jigesh16 — Wed, 29 Aug 2018 13:43:53 GMT

Hi Sunny,

Sorry for the late reply.

Was able to resolved the issue using IF inside aggr function. earlier we were using Variable.