topic Re: Calculate Growth in QlikView

Calculate Growth

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

Hi,

I want to create a D-growth chart.

It means, If my target value is 10 and sales is 6 and dimension is products.

want to draw a bar chart where dimension will be products name and in expression there would be my D-growth calculation (Those product will be displayed which are behind the target)

I use this formula:

=if(sum(ExtInvMisc)<sum(TargetAmount),ColumnName)

but its not working.

Thanks in advance

Re: Calculate Growth

Anil_Babu_Samineni — Sat, 09 Jun 2018 13:36:06 GMT

Can you try this?

=if(sum({<ExtInvMisc = {"=Sum(ExtInvMisc)=10"}>} ExtInvMisc)<sum({<TargetAmount = {"=Sum(TargetAmount)=6"}>} TargetAmount),ColumnName)

If(Sum(Sales) = 6 and Sum(target) = 10. Column)

Re: Calculate Growth

isingh30 — Sat, 09 Jun 2018 16:03:49 GMT

Can you share your data in excel format?

Re: Calculate Growth

Anonymous — Sun, 10 Jun 2018 04:45:50 GMT

Thanks to all......I did it..

Below expression works as i want;

=if(sum(ExtInvMisc)<sum(TargetAmount),sum(ExtInvMisc))

Re: Calculate Growth

arvind1494 — Sun, 10 Jun 2018 09:16:58 GMT

=if(sum(ExtInvMisc)<sum(TargetAmount),sum(ExtInvMisc))