topic Re: variables in QlikView

variables

Wed, 25 Mar 2015 16:45:50 GMT

How to define variable like below.

Format required: YYYYMMDD

vsomething= today minus 40 days. so in this case vSomething=20150215 (40 days from today)

caviat: condition where year has to be current year. In this case if this variable got executed on january 20 (where 40 days minus falls into 2014), it will default the start date to 20150101

Thanks for the help in advance.

Re: variables

jpenuliar — Wed, 25 Mar 2015 16:52:39 GMT

vPast40Days = Date(Today() - 40, 'YYYYMMDD');

Re: variables

luciancotea — Wed, 25 Mar 2015 16:54:38 GMT

= date( if( Today()-40 < YearStart(Today()) , YearStart(Today()) , date(Today()-40) ) , 'YYYYMMDD')