Discussion Board for collaboration on QlikView Layout & Visualizations.
I am trying to find a solution for this issue:
I just have this excel with this information:
Member > Guest
Reg Date > Registration Date when the guest signs in.
Ter Date > Termination Date when the guest signs out.
Entrance Fee and dayly Fee.
I want to track which are my incomes every day from the first date of Reg Date till today (when today is the day I reload the document).
Something like this:
If I reload the document the 05th of JulyI have to obtain the rest of the days automatically, so I can track my incomes by just using the first imput excel.
Is there anyway I can achieve this?
Thanks a lot in advance.
PD. Excel attached.
Any idea anybody?
See attached qvw.
That was great!
Thanks a lot...