Discussion board where members can get started with Qlik Sense.
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(Floor([VRU_DateTime Arrived])) as VRU_From_Date
Date(Floor([VRU_DateTime Arrived])) as VRU_To_Date
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.
You can create list box of To Date as below..
IF([To Date] >= [From Date], [To Date])
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.
This is coming like this:
But data wise it is good.
How to rectify this.