Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

lfalmoguera
New Contributor III

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
New Contributor III

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

Any idea anybody?

Regards

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

See attached qvw.


talk is cheap, supply exceeds demand
lfalmoguera
New Contributor III

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

That was great!

Thanks a lot...

lfalmoguera
New Contributor III

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

That was great!

Thanks a lot...

Community Browser