topic issue with total in QlikView

issue with total

Mon, 28 May 2012 07:35:12 GMT

Hi,

the attached problem seems easy but difficult to fix for me.

Some help?

Mon, 28 May 2012 08:22:51 GMT

Hi Nick,

you can do something like this for the third column:

if(Column(1) > 0 and Column(2) > 0, sum(VAL1)/sum(VAL2) , null())

And change the total mode of the third expression to be "Average of Rows"

Stefan

Mon, 28 May 2012 08:48:46 GMT

Hi Stefan,

Tried and it wont work.

In fact, even if it work, i can't use it. because i'm needing the total to plot a line chart.

the table is just to test out the formula...

Mon, 28 May 2012 10:46:28 GMT

Hi Nick,

Is 500% the total wanted in the TOTAL row (first one)?

Use this expression then:

sum(VAL1/VAL2).

Hope it helps.

Tue, 29 May 2012 01:40:16 GMT

Ola Borja,

Thanks for the suggestion.

But in fact, i'm trying to get 250% percent.

meaning, the values i wanted to take into account are Feb and Mar, because both val1 and val2 are not 0.

thanks.