topic Re: Aggr issue Chart Table in QlikView

Aggr issue Chart Table

Thu, 29 May 2014 12:56:50 GMT

Hi,

I'm having a problem creating a chart table like this:

Product Region Product Growth All Products Growth

A 1 5% 7%

B 1 3% -

A 2 5% 4%

B 2 7% -

In the column "All Products Growth" I need the value to be is all region rows, but its not happening!

Thanks in advance,

Francisco

Thu, 29 May 2014 13:02:15 GMT

correction:

Product Region Product Growth Region / All Products Growth

A 1 5% 7%

B 1 3% -

A 2 5% 4%

B 2 7% -

In the column "Region / All Products Growth" I need the value to be is all region rows, but its not happening!

lironbaram — Thu, 29 May 2014 13:10:40 GMT

may be you can use total instead of aggr

something like sum(total <Region> currentsales)/sum(total <Region> previoussales)

Thu, 29 May 2014 13:38:38 GMT

Hi Liron,

That helps a lot for the first part of my problem (Current / Prevoius) but I also need to calculate the previoussales:

normaly I use somenting like this:

aggr(sum ({<$(vMonth_LY)>} sales), $(Dim_in_Table))

how can I integrate the Total so the lines is all filled?

Thanks very much,

Francisco

Thu, 29 May 2014 13:40:47 GMT

correction:

aggr(sum ({<Region=, Product=, $(vMonth_LY)>} sales), Region, Product)