This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a date expression which I would like to restrict from 2017 onwards.
Is it possible to add 'YEAR(StockDate)>2016 ' to the above expression?
Thank you in advance!
what's your goal?
At the moment I have data going back to 2012, so hoping to update this expression to only show data from 2017.
In back end you can add where condition to your script
Where Year >='2017';
Or in front end use
if(Year>=2017,Year) as your dimension
or You can create same dimension in your script if you want to allow all the years data but in one table if you only want data from 2017
if(Year>=2017,Year) as Years