Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save $300 - Register for QlikWorld (formerly Qonnections) by January 31st: Learn More
Highlighted
onkar1988
New Contributor II

Display specific values in date filter

Hi All,

I have a requirement to populate specific quarters in the date filter.  I have data for Q3 2019, Q2 2019, Q1 2019 and Q4 2018 in data. I am pulling data from below table where in current quarter is where flag ='N'.

Period_IDPosition_YearPosition_QuarterPeriod_Closed_flagsales
12018Q4Y100
22019Q1Y200
32019Q2Y300
42019Q3N400

 

I want to display (current-1) quarter and last quarter of prior year always in 'historic period' filter.

If my current quarter is Q3 2019,  I want to display Q2 2019 and Q4 2018 in 'historic period' filter.

If my current quarter is Q4 2019, I want to display Q3 2019 and Q4 2018 in 'historic period' filter.

Let me know if I am clear with my requirements. Thanks 🙂

Regards,

Onkar Kulkarni

Labels (3)
2 Replies

Re: Display specific values in date filter

Display this where? I am not sure I understand where exactly is this displayed and how?

onkar1988
New Contributor II

Re: Display specific values in date filter

Hi Sunny,
Thanks for the reply. I want to display it in Filter pane- 'Historic Period'.