Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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

2 Replies
Highlighted

Re: Display specific values in date filter

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

Highlighted
Contributor III
Contributor III

Re: Display specific values in date filter

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