Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Update 0 or null data with the previous data on Chart

Hello All

I am new to QlikView and am having some Issues creating an expression.

in my expression i need to display or auto update sections where there 0 or null data with the previous data

Example :

Data

Week #      Measure

W1          200

W2          300

W3          Null

W4          250

W5          300

W6          Null

W7          Null

W8          400

Need to be Displayed as

Week #      Measure

W1          200

W2          300

W3          300

W4          250

W5          500

W6          500

W7          500

W8          400

This calculation need to be done on a Chart not on the Load Script.

1 Solution

Accepted Solutions
MVP
MVP

dimension          Week #

expression          if(len(trim(Measure))=0, above(sum(Measure)), sum(Measure))

sort by Week #

View solution in original post

4 Replies

Can you please provide an example or your document?

Not applicable

Hello Alessandro

Please find attached a qvw with dummy Data & Chart.

MVP
MVP

dimension          Week #

expression          if(len(trim(Measure))=0, above(sum(Measure)), sum(Measure))

sort by Week #

View solution in original post

Not applicable

Thanks...this is exactly what i needed