Qlik Community

New to Qlik Sense

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rsingh43
Creator
Creator

Year Filter

Hi,

I have a date expression which I would like to restrict from 2017 onwards.

=date(FLOOR(MonthEnd(StockDate)),'MMMYYYY')


Is it possible to add 'YEAR(StockDate)>2016 ' to the above expression?

Thank you in advance!

3 Replies
agigliotti
Partner
Partner

what's your goal?

rsingh43
Creator
Creator
Author

At the moment I have data going back to 2012, so hoping to update this expression to only show data from 2017.

MK9885
Master II
Master II

In back end you can add where condition to your script

Load

Year,

....

From ABC

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

Load

Year,

if(Year>=2017,Year)  as Years

From ABC;