Discussion board where members can get started with Qlik Sense.
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
This is needed throughout the dashboard or on a particular chart?
Thanks for reply
I need throughout the dashboard
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?
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.
Alternatively, you can create an The As-Of Table where a single month is associated with last 6 months... something like this
and so on...
now when you select Apr-2018 in AsOfDate, it will select 6 months in Date