Qlik sense - Action - Select Values in

[aheavy95]

Hi all

Im trying to set an action - defaultly opening the sheet as current month & last month are selected.

I managed to add either current or last month but couldn't both.

What should I insert in the 'edit expression'?

I've tried:   TheMonth> month(today())-1 

And: max(TheMonth) or max(TheMonth)-1
both didn't work.

Thanks

[udit_k]

for max month use:-=MaxString(Month)
,

For previous month use :-=text(monthname(addmonths(MaxString([Start Date]),-1)))

[aheavy95]

thanks, I need one action that would give me both ( to show months that are greater than previous month)

[PrashantSangle]

Try below

Action > Select values matching search Criteria

Values > ='>=$(=MonthStart(Today(),-1))'

Regards,

Prashant Sangle

[aheavy95]

The script works, but thae action doesn't work as once I enter the page the months arent filtered

[rbartley]

Hi @aheavy95 ,

Have you tried creating a bookmark and using the action "Apply bookmark" insetad?

[PrashantSangle]

how you navigate your sheets??? using button ? or using qlik provided navigation ???

If you are using button then above logic work

if you are using qlik provided navigation then use bookmark for it.

Regards,

Prashant Sangle