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

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

Anonymous — Tue, 01 May 2018 14:45:10 GMT

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,

Qrishna — Tue, 01 May 2018 15:16:56 GMT

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 — Wed, 02 May 2018 06:48:43 GMT

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