Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Need to allign days in current to previous year

~~ To Display on Dashboard ~~

Current Year Actuals and Variance

WednesdayThursdayFridaySaturdaySunday
1/2/20131/3/20131/4/20131/5/20131/6/2013
1/1/20141/2/20141/3/20141/4/20141/5/2014
Actual CYActual PYVarianceActual CYActual PYVarianceActual CYActual PYVarianceActual CYActual PYVarianceActual CYActual PYVariance
200100100.00%150200-25.00%21015040.00%20017514.29%1901758.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 ?

Tags (1)
2 Replies
Not applicable

Re: Need to allign days in current to previous year

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

Not applicable

Re: Need to allign days in current to previous year

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

Sample.PNG.png

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 CYActual PY
553551

Thanks,

Sailee