Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date range

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

2 Replies
Not applicable
Author

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

Not applicable
Author

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