topic Re: Expression Help in QlikView

Expression Help

Anonymous — Fri, 16 Nov 2018 13:41:53 GMT

HI All,

I have the follwing dimensions Product Group, Country, Part Type.

I have written the following expression in straight table chart for Market NR:

=sum(Consumption)/sum(aggr(avg([Install Base]),[Product Group],[Part Type],Country))/(sum(TOTAL Consumption)/sum(TOTAL aggr(avg([Install Base]),[Product Group],[Part Type],Country)))

Now this is working when i filter .

For ex i have Affintiti 30 Product Group and Normal part type and country Brazil is selected then value is coming as 196 which is correct:

Now when i un-filter i am getting wrong value as 315:

Can you please help me where i am doing wrong.

Attached qvw.

Thanks,

Bharat

Re: Expression Help

sunny_talwar — Fri, 16 Nov 2018 13:51:15 GMT

Try this

=Sum(Consumption)/Sum(Aggr(Avg([Install Base]),[Product Group],[Part Type],Country))/
(Sum(TOTAL <[Product Group], [Part Type]> Consumption)/Sum(TOTAL <[Product Group],[Part Type]> Aggr(Avg([Install Base]), [Product Group], [Part Type], Country)))

Re: Expression Help

Anonymous — Fri, 16 Nov 2018 13:56:18 GMT

Thank you Sunny Bhai... Sorry forget to take total only for those 2 fields.I am taking total for all that is wrong.. Thank you so much Sunny Bhai...Thanks...