Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Shahzad_Ahsan
Contributor II

Filter date from selected date to last 6 Months

Hi Everyone

I have an issue. I have a date fields like 'TranDate'

I need to use this as a filter. If I select any date, the result should show last 6 months from that selected date.

Suppose I select 05-May-2018 from the filter, so the result should be from 05-Nov-2017 to 05-May-2018

5 Replies
MVP
MVP

Re: Filter date from selected date to last 6 Months

This is needed throughout the dashboard or on a particular chart?

Shahzad_Ahsan
Contributor II

Re: Filter date from selected date to last 6 Months

Hi Sunny

Thanks for reply

I need throughout the dashboard

MVP
MVP

Re: Filter date from selected date to last 6 Months

May be use a trigger extension from Qlik Branch to trigger selection on 6 months when a month is selected. But why can't you ask your users to select 6 months?

Shahzad_Ahsan
Contributor II

Re: Filter date from selected date to last 6 Months

Thanks for your suggestion

I will try this extension

May be I will create month and year filter and ask them to select 6 months.

MVP
MVP

Re: Filter date from selected date to last 6 Months

Alternatively, you can create an The As-Of Table where a single month is associated with last 6 months... something like this

AsOfDate     Date

Apr-2018     Apr-2018

Apr-2018     Mar-2018

Apr-2018     Feb-2018

Apr-2018     Jan-2018

Apr-2018     Dec-2017

Apr-2018     Nov-2017

Mar-2018     Mar-2018

Mar-2018     Feb-2018

Mar-2018     Jan-2018

Mar-2018     Dec-2017

Mar-2018     Nov-2017

Mar-2018     Oct-2017

and so on...

now when you select Apr-2018 in AsOfDate, it will select 6 months in Date