Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Dolly123
Creator II
Creator II

set analysis

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

Labels (4)
2 Replies
RP_Bingi
Contributor
Contributor

Set vStartDate= '01/01/2021';

Set vEndDate='11/11/2023';

Measure: Sum({$<Date={">$(vStartDate)<$(vEndDate)"}>}Sales)

Load * where StartDate<=$(vEndDate) and EndDate>=$(vStartDate); 

Aasir
Creator III
Creator III

Name: vDateRange

Expression: '>=01/01/2021 <=11/01/2023'

Use the variable like this.

LOAD
Field1,
Field2,
...
FROM YourDataSource
WHERE DateField $(vDateRange);