Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sarag_pillai
Contributor III
Contributor III

accumulation not making sense

hi I have an chart which has null values

QRKeyRevenue
01-04-20130100
01-01-20141200
01-02-20142300
01-03-20143400
01-04-20144500
01-01-20155-
01-02-20156-
01-03-20157-

and I want chart like this pls help

QRKeyR
01-04-20130100
01-01-20141200
01-02-20142300
01-03-20143400
01-04-20144500
01-01-20155500
01-02-201561000
01-03-201572000
10 Replies
jonathandienst

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
sarag_pillai
Contributor III
Contributor III
Author

here is the attachment

and my result should be like this

QRKeyR
01-04-20130100
01-01-20141200
01-02-20142300
01-03-20143400
01-04-20144500
01-01-20155500
01-02-201561000
01-03-201572000
Not applicable

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

If possible share the source xls file.

tresesco
MVP
MVP

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

sarag_pillai
Contributor III
Contributor III
Author

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

here is my source file

sarag_pillai
Contributor III
Contributor III
Author

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
MVP
MVP

May be like attached sample?

PFA

sarag_pillai
Contributor III
Contributor III
Author

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

prasenna
Contributor II
Contributor II

hi sara,

try this

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