Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

hi sara,

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