Discussion Board for collaboration related to QlikView App Development.
I have taken Date as dimension and sum(Application_sales) as Measure. I need to consider last day sales if i dnt have sales on that day.
01-04-2018 , 200
Here, I need to show sales of 02-04-2018 ( 400 ) to 03-04-2018 and 04-04-2018 also. please find the attached image.
Please help me in this.
Go to Solution.
For front-end solution, try like:
View solution in original post
You can try loading like:
If(Sales=0, Peek(Sales), Sales) as Sales
It is working fine. Thank you so much.