Hi Qlik Experts,
I have a Island table which contains Date fields in it, the dates are extraction dates of historical table.
I want to do comparision between two dates in the table and need to get the graph results. I am done visualization part.
Now my task is, if i select one date in one filter then another has to show only >= selected dates in another filter.
1) It should not be possible to select the date in the right box prior the date in the left list box.
2) It should not be possible to select more than one date in the list boxes
Below is my smaple script and i have attached my sample qvw file also. screen shorts also.
// system variables
SET HidePrefix = '%'; // hides fields starting with this prefix
DateTable:
LOAD * INLINE [
"Extraction Date"
01/01/2021
01/02/2021
01/03/2021
01/04/2021
01/05/2021
01/06/2021
];
NoConcatenate
//Actual Date
TimeToTimeExDate:
LOAD Distinct
Date([Extraction Date],'YYYY-MM-DD') as %ActExDateTimeStamp
RESIDENT DateTable;
//Historical Date
Outer Join (TimeToTimeExDate)
LOAD Distinct
Date([Extraction Date],'YYYY-MM-DD') as %HistExDateTimeStamp
RESIDENT DateTable;
Thank you in advance
Regards
Venkatesh