Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

julie_waugh
New Contributor

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

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?

2 Replies
sureshqv
Esteemed Contributor III

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

your loading data from  script?

try this

Where DateField>= '01MAY2018';



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

julie_waugh
New Contributor

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

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?

Community Browser