Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mhmmd_srf
Creator II
Creator II

To Date Selection should be Greater Than From Date

Hi All,

I have one table and one date field VRU_NewDate. I had to make two date Filter From Date and To Date.

I have created two Resident table and two variable fro that. Below is the script.

Date_From:

Load

Date(Floor([VRU_DateTime Arrived])) as VRU_From_Date

Resident OLA_Service_Desk_VRU;

Date_To:

Load

Date(Floor([VRU_DateTime Arrived])) as VRU_To_Date

Resident OLA_Service_Desk_VRU;

Set v_FromDate = Min(VRU_From_Date);

Set v_ToDate  = Max(VRU_To_Date);

Data is coming fine.

However user demands that when he will select any date from From Date filter, To Date filter will be showing Selected Date onward, not all dates.

Could you please help me how to implement this.

Thanks,

Sarif

3 Replies
MK_QSL
MVP
MVP

You can create list box of To Date as below..

IF([To Date] >= [From Date], [To Date])

mhmmd_srf
Creator II
Creator II
Author

Hi Manish,

I have already tried this logic. It is showing correct value in List Box. But when I am selecting any date from To Date filter, From Date filter changes to All.

Please suggest.

Sarif

mhmmd_srf
Creator II
Creator II
Author

Manish,

This is coming like this:

But data wise it is good.

How to rectify this.

Thanks,

Sarif