topic 5 dates range selection in QlikView

5 dates range selection

Anonymous — Mon, 23 May 2016 05:53:26 GMT

Hi Friends,

I have a table as shown below

Id	Date1	Date2	Date3	Date4	Date5
1	5-Apr	5-Jan	4-Feb	23-Jan	20-Jan
2	1-Feb	3-Jan	4-May	5-Feb	9-Jan
3	5-Mar	5-Jan	4-Feb	23-Jan	20-Jan
4	4-Jan	12-Feb	12-Mar	18-Mar	20-Jan
5	3-Apr	3-Jan	4-May	5-Feb	9-Jan
6	3-May	5-Jan	4-Feb	23-Jan	20-Jan
7	8-May	12-Feb	12-Mar	18-Mar	20-Jan

my requirement to fetch all the id from month/date selected till next 60 days. So here i am reading the table row wise .

Note: all the above dates all linked to master calender.

For Example:

if i select April 2016, then it fetch all the id between April and may.

as i read the records row wise, so in that row, if any of the date falls between april and may then that row need to be fetched if not rejected.

so as per the above table when i select april 2016,

i need to fetch the following id

1,2,5,6,7

thanks in advance

Re: 5 dates range selection

sujeetsingh — Mon, 23 May 2016 05:58:50 GMT

Hey you need to add trigger for this on Month field or Date field. Hence write trigger on select in field action Where Date >=Selected value and Date <= 60+Selected date.Follow this link

Use trigger to select values in one field based... | Qlik Community

Set trigger to select multiple values in a field from a variable

This link below meets your requirement to some extent

Select last 7 Days in QlikView Document

Re: 5 dates range selection

Anonymous — Mon, 23 May 2016 10:17:11 GMT

Thanks....

Re: 5 dates range selection

ashishkalia — Mon, 23 May 2016 10:31:11 GMT

You can try this:

STEP1:

Load ID,

Date1 as Date

Resident Table;

concatinate

Load ID,

Date2 as Date

Resident Table;

Concatinate

Load ID,

Date3 as Date

Resident Table;

Concatinate

Load ID,

Date4 as Date

Resident Table;

Concatinate

Load ID,

Date5 as Date

Resident Table;

This will make your data in a systematic and more desired manner.

STEP2

Make a master calender.

STEP3

Make a mapping month like:-

LOAD * INLINE [

Month, MapingMonth

Apr, Apr

Apr, May

May, May

May, Jun

Jun, Jun

Jun, Jul

Jul, Jul

Jul, Aug

Aug, Aug

Aug, Sep

Sep, Sep

Sep, Oct

Oct, Oct

Oct, Nov

Nov, Nov

Nov, Dec

Dec, Dec

Dec, Jan

Jan, Jan

Jan, Feb

Feb, Feb

Feb, Mar

Mar, Mar

];

link it with your calander via Month and make selection on Mapping Month.

This may help.