Limit a date field to just show a certain date eg >= 01MAY2018 in Qliksense app

[Anonymous]

Hi,

I'm new to Qlik Sense and would like to either create a new date field eg date >= "01MAY2018" or restrict the existing date field to only show dates greater than or equal to "0MAY2018". Can this be done without having to sum up / count a field value?

[Chanty4u]

your loading data from  script?

try this

Where DateField>= '01MAY2018';

Note: Date format should match the same with where value.

[Anonymous]

Hiya,

No not in script.

I have 2 years worth of data in the App, but on one of the sheets I just wanted to drag the date field onto the sheet as a filter (currently this shows all the dates from '01Jul2016' to '01Jul2018'). However I would like to only show dates from '01May2018' onwards. How would I do this?

[Ragnar]

Chanty4u, - thanks for your solution. Was plucking hair as my dates weren't showing >= onwards until I found your comment after trying various to no avail.

You the man.