Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
~~ 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 ?
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
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