Default selection on open trigger to previous month Till current month 7th day

[Anonymous]

Hi Guu,

I want to keep default selection on Year ,Month Fields in Qlik sense on open app

for this iam using default selection extension.

Till 7Th day of May it should show March data and from 8th day of May   it should show April data

here are the expressions using in Each of the extension:

Year

=if(Len(GetFieldSelections([Year]))=0,

Max({1<

$(vSetPreviousFULLMonthModifier)

>}[Year]))

Month

=if(Len(GetFieldSelections([Month]))=0,

Max({1<

$(vSetPreviousFULLMonthModifier)

>}[Month]))

Till now these extensions showing Current year and Last Month.

Now I want to update the logic as below:

Till 7Th day of May it should show March data and from 8th day of May   it should show April data.

Thanks,

[krishna_2644]

may be this :

Month

=if(

     Len(GetFieldSelections([Year]))=0 and Date.No<= YourMayMonthValue,Max({1<$(vSetPreviousFULLMonthModifier)>[Month]) ,

YourElseFieldExpression

)

Share a mock-up in case the above doesnt work for you.

[Anonymous]

Hi Krishna,

Thanks for your Time.

I have field Date serial in my app and values are like below

43221

43222

43223

43224

43225

43226

43227

how to write in set analysis expression