Discussion board where members can get started with Qlik Sense.
I have 2 variables set up as start and stop date named:
I want to set up a date range limitation via set analysis to be used on a chart so that the chart will only display data for the range between these 2 dates.
I managed to set up the vEndDate limit but i can't figure out how to add the second condition (vStartDate). Can you please help me with the syntax?
This is my set analysis with the EndDate condition which is working:
Go to Solution.
Try adding an equal sign in front of your vStartDate variable definition:
I assume, that your default date format is 'DD/MM/YYYY', otherwise add the date format to Date() function.
Thanks Stefan but the syntax does not change the date range as I wanted it to.
Here are my variables:
I have a feeling this has to do with the way I defined the vStartDate...?
My table looks like the below. with the added set analysis expression It currently ends on 31/07/2017 but starts on 31/07/2016. I want it to start from a month before today's date (e.g. 20/12/2016)
Thanks Stefan! Adding a "=" at the beginning of the variable did the trick!