Quaterly Cut-Off date report

ruudkamp — Tue, 09 May 2017 09:55:32 GMT

Hi,

I need to allocate historical value’s to a quarterly cut-off date report. When an amount is changed, I have record with DateChanged and the new Amount . My Input data looks like:

EmployeeID	ExpenseType	DateChanged	Amount
A	Salary	01-01-16	500
A	Salary	15-04-16	550
A	Salary	01-01-17	575
A	Travel	01-01-16	10
A	Travel	15-05-16	0
A	Travel	01-01-17	15
B	Salary	01-02-16	390
B	Salary	01-01-17	410
B	Travel	01-02-16	17
B	Travel	01-01-17	19

The report I need is:

EmployeeID	ExpenseType	01-01-16	01-04-16	01-07-16	01-10-16	01-01-17
A	Salary	500	500	550	550	575
A	Travel	10	10	-	-	15
B	Salary	-	390	390	390	410
B	Travel	-	17	17	17	19

Who can help me?

The Excel model is attached - Ruud Kamp

Re: Quaterly Cut-Off date report

Anil_Babu_Samineni — Tue, 09 May 2017 10:59:03 GMT

In your data you don't have few dates which you are showing Data set. Does this true, If so then please help us the logic behind

Re: Quaterly Cut-Off date report

ruudkamp — Tue, 09 May 2017 12:28:53 GMT

Hi,

I have attached the qvw model.

And the required output for employee A only Salary,(PDF)

thx a lot

topic Re: Quaterly Cut-Off date report in QlikView

Quaterly Cut-Off date report

Re: Quaterly Cut-Off date report

Re: Quaterly Cut-Off date report