Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kamielrajaram
Creator III
Creator III

Pivot table- get previous value

Good day all,

I have a pivot table with 4 dimensions one being random dates, this date field forms the column headings. Some of the rows may have a value for a certain date and for the same row there may be a 0 value for one or more of the date columns. I need to populate the 0 rows with the previous non 0 value..

 

Thank you 

Kamiel

1 Solution

Accepted Solutions
dapostolopoylos
Creator III
Creator III

There is Before() function that could help you with your issue, take a look here: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Father/Husband/BI Developer

View solution in original post

1 Reply
dapostolopoylos
Creator III
Creator III

There is Before() function that could help you with your issue, take a look here: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

Father/Husband/BI Developer