Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a the following issue. The following data set is available.
Run | Startdate | Enddate | Frequency |
1 | 1-1-2012 | 30-12-2013 | 2 |
2 | 1-1-2013 | 11-2-2013 | 4 |
3 | 12-2-2013 | 15-6-2014 | 1 |
Total | 7 |
I also have a Year listbox which is the Year(Startdate) function.
Year |
2012 |
2013 |
2014 |
When I select year 2012 in the list box it shout give me run 1, 2 and 3 with a total of 7 (total of field Frequency). When I select year 2013 it should give me run 2 and 3 with a total of 5 (total of field Frequency).
What is does now is when I select only the year which matches thus 2012 only 2012 is given which gives a total of 2 (total of field Frequency).
So my question is how do I program Qlikview to get the whole data set corresponding to the year (Startdate) selected.
Thanks!!!
Hi,
Try like
If you are calculating Year at front end then
use below expression in text Obejct
Sum({<StartDate={">=$(=Date(max(StartDate)),'DD-MM-YYYY')"}>}Run)
If you calculate Year At back end
then use below expression in text Obejct
Sum({<Year={">=$(=max(Year))"}>}Run)
Regards