Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joshibabu_are
Contributor
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
Chanty4u
MVP
MVP

try this

=MonthName(Today(),-1)

joshibabu_are
Contributor
Contributor
Author

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
Partner - Contributor III
Partner - Contributor III

What about:

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