Date range when you select year from listbox

basaiuser — Thu, 09 Oct 2014 08:37:32 GMT

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!!!

Re: Date range when you select year from listbox

PrashantSangle — Thu, 09 Oct 2014 08:44:41 GMT

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

topic Re: Date range when you select year from listbox in QlikView

Date range when you select year from listbox

Re: Date range when you select year from listbox