topic Re: Chart Expression in QlikView

Chart Expression

Fri, 07 Nov 2014 14:37:26 GMT

Hello,

I have two expressions i.e. sum(sales) , gives the sales for each year for selected country

and second one is sum(TOTAL <Year> aggr( sum(sales),Year)), gives total sales for all the years for selected country, now am trying to calculate the share from these expression means sum(sales)/sum(TOTAL <Year> aggr( sum(sales),Year)) but am not getting desired result just am getting 100% share all the years, how to calculate the expression from these expression?

Re: Chart Expression

miikkaqlick — Fri, 07 Nov 2014 14:44:48 GMT

Hi!

Like this:

Divide Column(1) by Column(2) and show result as percentage.

Miikka

Climber

Re: Chart Expression

Fri, 07 Nov 2014 15:03:38 GMT

Hi,

Thanks for your replay, I have already tried with Column(1)/Column(2) but it doesn't work from me.

Re: Chart Expression

JonnyPoole — Fri, 07 Nov 2014 15:13:47 GMT

Usually the TOTAL syntax is used to subtotal the expression by chart dimensions... so dimensions that are included in the chart . Is it in your chart ? If not, you could also try:

sum(sales)

aggr( sum(sales),Year)

sum(sales)

sum(aggr( sum(sales),Year))

or post a sample qvw for better guessing

Re: Chart Expression

MK_QSL — Fri, 07 Nov 2014 15:44:45 GMT

Use

SUM(Sales)/SUM(TOTAL <Year> Sales)