Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

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
Partner

What about:

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