Need Help of Qlikview

[#1]

Hello -  I am new to qlikview and trying out to do YTD, PYTD Calculation and running into Issues and would need help.

Assuming my data set is as below -

Order Date	Customer	Amount
1/2/2007	John	100
1/3/2007	Miller	200
1/4/2007	Scott	300
1/5/2007	Peter	400
1/2/2008	John	100
1/3/2008	Miller	200
1/4/2008	Jack	500
1/4/2008	Jerry	600
1/4/2008	Mike	700

I want to Pass 1/4/2007 as the Input Value and would like to calculate YTD and PYTD Values and the result output as below -

Customer	2008	2007
John	150	100
Miller	200	200
Scott	0	300
Jack	500	0
Jerry	600	0
Mike	700	0

Ideally I would like to have the Calendar as Prompt from which I should be able to pick a date and display the calculation as above. I have tried using Multibox for the user to pick Date,Month, Year and use Yearstart as "YearStart(Max(DateNum)"  and (=Max(DateNum)) but running into challenges can some one help me out on this.

I would like to have the Multi Box'es for Year, Month, Date for users to choose.

would greatly appreciate any help.

Thanks

Rahul K

Thanks

Rahul K

[aveeeeeee7en]

Hi

See the Attachment.

Regards

Aviral Nag

[#3]

Thanks Nag for the reply.

I am not looking for just a Year, but user should be able to choose a particular date of the Year and calculation should work. I am new to Qlikview so I have only Personal Edition so would not be able to opel QVW's more than 4 times if you can send me the snippets of the code that would be very helpfull.

Thanks

rahul K

[aveeeeeee7en]

See this Post:

Current Period and Last year Same Period