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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
lfalmoguera
Creator
Creator

Build an Incomes Calendar with Just Registration Date - End Date and Tariff.

Hi guys,

I am trying to find a solution for this issue:

I just have this excel with this information:

MEMBERREG DATETERM DATECUST TYPEENTRANCE FEEDAYLY FEE
LUIS01/06/201312/06/2013110050
PABLO05/06/201315/06/2013110050
LUCAS08/05/20131100             50
MARIA10/06/2013 2200100

Where:

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:

MEMBER01/06/201302/06/201303/06/201304/06/201305/06/201306/06/201307/06/201308/06/201309/06/201310/06/201311/06/201312/06/201313/06/201314/06/201315/06/201316/06/201317/06/201318/06/2013
LUIS1505050505050505050505050000000
PABLO0000150150150150150150150150150150150000
LUCAS000000015050505050505050505050
MARIA000000000300100100100100100100100100

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.

Regards

4 Replies
lfalmoguera
Creator
Creator
Author

Any idea anybody?

Regards

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw.


talk is cheap, supply exceeds demand
lfalmoguera
Creator
Creator
Author

That was great!

Thanks a lot...

lfalmoguera
Creator
Creator
Author

That was great!

Thanks a lot...