topic Date range in QlikView

Date range

Mon, 18 Jul 2011 13:32:18 GMT

Hi,

I am new to Qlikview and in need of some help. I have a qvd file that has the following:

lic_no,lic_desc,out_date,in_date

I need to make a calendar that shows me all the results that are in the range.

For example:

The user selects the interval 14-16 July 2011. I need to get the results that have the out_date<14 july 2011 and the in_date>16 July.

I have tried to use the master calendar with no luck so far. Please help

Mon, 18 Jul 2011 15:49:13 GMT

Approch would be,

a. Load your Data in Table1

b. Create a New table which has all the dates

C. In chart compare the date Values and based on that show you message

Tue, 19 Jul 2011 08:47:15 GMT

That works if they select a single date. But what if the user selects form the date table two or more dates?