Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?