Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

joshibabu_are
New Contributor

Default selection Extension in Qlik sense

Hi Guru's,

I Have Year,Quarter,Month,YearMonth  are the Filter Objects in qlik sense Application

I want to use On open Trigger using Extension to Current "YearMonth" Minus 1      i.e 2018-feb 

What expression do i need to write in Extension to achieve this.

stalwar1

Thanks,

Joshi

3 Replies
sureshqv
Esteemed Contributor III

Re: Default selection Extension in Qlik sense

try this

=MonthName(Today(),-1)

joshibabu_are
New Contributor

Re: Default selection Extension in Qlik sense

Hi Chanty,

=MonthName(Today(),-1) returning 2/1/2018 But my Year Month Field format is 2018-Jan,2018_feb ......



How to achieve the same

bertdijks
New Contributor III

Re: Default selection Extension in Qlik sense

What about:

=max({<LastMonthFlag={'1'}>}YearMonth)

Community Browser