I have a report that runs daily that I transform into a report similar to the attached.
It shows daily balances start and end of day. The end of day balance == the start of day balance of the next day.
Monday end of day == Tuesday start of day
Tuesday end of day == Wednesday start of day
yadda yadda yadda
I am looking for tips and tricks to recreate this report to show in Qlik.
Mainly the part of the start of day v end of day. I can get these showing in a line across time in a pivot table, but splitting the values between start of day and end of day is where the struggle occurs.
Would I create a placeholder flag as 'start' and 'end' and place that flag indicator as a dimension?
Everything not saved will be lost
— Nintendo Quit screen message
