Need to allign days in current to previous year

[#1]

~~ To Display on Dashboard ~~

Current Year Actuals and Variance

Wednesday

Thursday

Friday

Saturday

Sunday

1/2/2013

1/3/2013

1/4/2013

1/5/2013

1/6/2013

1/1/2014

1/2/2014

1/3/2014

1/4/2014

1/5/2014

Actual CY

Actual PY

Variance

Actual CY

Actual PY

Variance

Actual CY

Actual PY

Variance

Actual CY

Actual PY

Variance

Actual CY

Actual PY

Variance

200

100

100.00%

150

200

-25.00%

210

150

40.00%

200

175

14.29%

190

175

8.57%

Hello ,

Above is the data that I need to display on my dashboard in the same format. Here, the first day in current month is aligned with same day in previous year.

Not really sure how to create this in qlikview . Can someone please help ?

[#2]

Hi i solved you problem by always calculation for example todays date -364. the outcome of this would bring you Wedensday in week 28 (I think thats the week no at the momente ;-))

I hope this hepls you a little bit because for me right now is not exactly clear what you are trying to achieve.

regards,

MT

[#3]

Thanks alot MT . This helped little . This is what i got :

The Values shown corresponds to year 2011, However , I need another expression which would displays the values in year 2010. E.g. My value on 1/1/2011 is 553 and value is 1/2/2010 .. table should display that value as well .

1/2/2010
1/1/2011
Sat
Actual CY	Actual PY
553	551

Thanks,

Sailee