topic Re: Re: accumulation not making sense in QlikView

accumulation not making sense

Anonymous — Wed, 04 Dec 2013 06:58:51 GMT

hi I have an chart which has null values

and I want chart like this pls help

jonathandienst — Wed, 04 Dec 2013 07:40:53 GMT

Please provide more information, preferably the source data file and a sample qvw with problem chart.

Regards

Jonathan

Anonymous — Wed, 04 Dec 2013 07:57:45 GMT

here is the attachment

and my result should be like this

Wed, 04 Dec 2013 08:07:09 GMT

Are the values 500, 1000 & 2000 for Revenue coming from your source file?

If possible share the source xls file.

tresB — Wed, 04 Dec 2013 08:21:13 GMT

Accumulation is not really making sense ! could you explain the logic, or it is adhoc ?

Anonymous — Wed, 04 Dec 2013 08:53:32 GMT

no it is not coming from source file it is just mulplying doubled its value..

here is my source file

Anonymous — Wed, 04 Dec 2013 08:55:33 GMT

Hi,

after key 4 the revenue should want to double is value

first it should repeat is previous value then it should double as 1000,2000,3000 for null values of revenue

tresB — Wed, 04 Dec 2013 10:01:15 GMT

May be like attached sample?

PFA

Anonymous — Wed, 04 Dec 2013 10:09:05 GMT

Thanks but what we want to do if we need this output in front end expression..

Anonymous — Thu, 05 Dec 2013 06:00:26 GMT

hi sara,

try this

if(Key>4,above(column(1))*2,sum(Revenue))

Anonymous — Thu, 05 Dec 2013 06:09:18 GMT

hi sara,

if(isnull(Revenue),above(column(1))*2,sum(Revenue))