Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to write a create variable for 1 jan 2021 & 1 nov 2023 in qliksense
and i need data for this range apply in scripts
Set vStartDate= '01/01/2021';
Set vEndDate='11/11/2023';
Measure: Sum({$<Date={">$(vStartDate)<$(vEndDate)"}>}Sales)
Load * where StartDate<=$(vEndDate) and EndDate>=$(vStartDate);
Name: vDateRange
Expression: '>=01/01/2021 <=11/01/2023'
Use the variable like this.
LOAD
Field1,
Field2,
...
FROM YourDataSource
WHERE DateField $(vDateRange);