Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Akshaya45
New Contributor II

Restricting Pane Filter

Dear All,

Please help me out below condition in Filter Pane...

I have a date fields which contains from Apr-2016 to Apr-2019 and i want to show only from Jan-2017 to Apr-2019 in the same date fields.

How do i write the expression in the date filter Pane. Kindly help on this !!!!

 

2 Replies
emrekaya
New Contributor III

Re: Restricting Pane Filter

maybe you can try something like if(date>'Dec-16',date,null())
Highlighted
Akshaya45
New Contributor II

Re: Restricting Pane Filter

Hi dear,

It will not work, it will give you the same value including 2016 Months, because your condition is true Date always Grater than 'Dec-2016'