Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
Bobi
Partner - Contributor II
Partner - Contributor II

What is the error in my variable?

Hi. Anyone who can see what the error is in my variable? I got right answer when using the YTD but this time I am substracting -1 to get last year YTD.  If i take away the 'YYYYMMDD' part I get a number. But i want it in that format and not written as 43000..

 

[Booking InYTD]={"$(=Date(Today())-1), 'YYYYMMDD')"}

2 Replies
pepecc
Contributor III
Contributor III

I think there is a sintax error.

 

Try this: Date(Today()-1, 'YYYYMMDD')

ksgo
Contributor II
Contributor II

It would appear the format is not within the DATE(,) and there are too many parentheses.

[Booking InYTD]={"$( =Date (Today() ) -1 ), 'YYYYMMDD' )"}