Re: Re: accumulation not making sense - Qlik Community

Anonymous · ‎2013-12-04

hi I have an chart which has null values

and I want chart like this pls help

jonathandienst · ‎2013-12-04

Hi

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

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Anonymous · ‎2013-12-04

here is the attachment

and my result should be like this

Report Inappropriate Content · ‎2013-12-04

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

If possible share the source xls file.

tresesco · ‎2013-12-04

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

Anonymous · ‎2013-12-04

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

here is my source file

Anonymous · ‎2013-12-04

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

tresesco · ‎2013-12-04

May be like attached sample?

PFA

Anonymous · ‎2013-12-04

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

Anonymous · ‎2013-12-05

hi sara,

try this

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