Discussion board where members can get started with Qlik Sense.
I've created four different variables as follows, however they're not working as expected. I'd like to know whether my reasoning was right or not.
1. I have a range selection of dates. Let's say, in a filter box, I've selected all dates from (DD/MM/YYYY)
06/03/2013 to 07/05/2013 Field I'm taking into account is [Date picker]
2. I've set this variable, vMinDate
this should return 06/03/2013
3. Third variable vYearDate
this should return 2013.
4. Fourth variable vYearJan
This should return 01/01/2013
Basically, selecting 06/03/2013 to 07/05/2013 in my [Date picker], by specyfing $('vYearJan') in an expression, I should get 01/01/2013.
Am I right? Or am I mistaking something while specifying these variables?
Thanks for your help.
Go to Solution.
Is there any specific reason why you want to use 3 to 4 variables when it can be done in one.
Your variable should be as per me.
It will return you the first date of the year.
I'll probably have to use them further in the future for creating other expression, but anyway, your expression should do the job.