Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mhmmd_srf
Contributor

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

Re: To Date Selection should be Greater Than From Date

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

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

mhmmd_srf
Contributor

Re: To Date Selection should be Greater Than From Date

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
Contributor

Re: To Date Selection should be Greater Than From Date

Manish,

This is coming like this:

But data wise it is good.

How to rectify this.

Thanks,

Sarif

Community Browser