Aggr Function Qlikview

[shah_jigesh16]

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,

JD

[sunny_talwar]

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

[shah_jigesh16]

Hi Sunny,

Sorry for the late reply.

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