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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Hemachandran1
Contributor II
Contributor II

Need to place Zero when value is null..

Hi all,

I am doing cumulative  sum in the backend script..

I have more dimensions as in the below image..

I have data in monthwise.. For some dimensions data is not present.. So i need to place zero to do cumulative sum..

For Ex upto Current I need to value. Please help on the same.

Hemachandran1_0-1692457798504.png

Hemachandran1_1-1692457908338.png

 

Labels (1)
1 Reply
Hemachandran1
Contributor II
Contributor II
Author

I need to get the value upto Max Month.

Ex : Month               Amount

       Jan                      100

       Feb                      10

       Jun                      3

In the above example , Mar - May value is not present.. For that i need to place zero..

Then only i can able to do cumulative sum..

Thanks