topic problem with cumultaive values in QlikView

problem with cumultaive values

Anonymous — Tue, 05 Feb 2013 17:49:02 GMT

for culmutaive values ----i'm using a expresion

= rangesum(above(sum(sales)),o,rowno(total))

it working fine

but the the issue is we want to supress values where sum(sales) =0 because in cumulATIVE we cannot see this zero value because it's show a previous values so the line chart is linear all over

how can i show my sUM(sales) =0 as 0 in cumulative..and once it's zero it can be suppresed

rangesum( if(sum(sales)=0,0,sum(sales)),0,RowNo(TOTAL))

but this didn't worked

Any suggestion plz

Re: problem with cumultaive values

Tue, 05 Feb 2013 18:35:11 GMT

Hi, if I understood you correctly, this is one way to do it :

Using the following example data :

LOAD * INLINE [

F1, F2

jan, 10

feb, 20

mar, 0

apr, 30

may, 40

jun, 0

jul, 50

];

Create a new straight table, add F1 as a dimension, then create the follwing 2 expressions :

Label : F2sum

Definition:

=rangesum( sum(F2),Above(F2sum))

It will create the cumulative column, then create the final expression :

=if(sum(F2) <> 0, F2sum) // to show null where sum is zero or

=if(sum(F2) <> 0, F2sum, 0) // to show zeroes

Then go to Presentation, select the F2sum column and hide it.

Re: problem with cumultaive values

Anonymous — Tue, 05 Feb 2013 18:39:17 GMT

Thank for your reply

it is working for this expression

(sum([Actual Production])=0,0,rangesum(above(sum([Actual Production]),0,rowno(total

))))

Thanks again