Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Creator
Creator

Qlik sense - Action - Select Values in

 

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

 

aheavy95_0-1689078510923.png

aheavy95_1-1689078609215.png

 

Labels (4)
6 Replies
udit_k
Partner - Creator II
Partner - Creator II

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

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

 

udit_k_0-1689080674074.png

 

aheavy95
Creator
Creator
Author

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

PrashantSangle

Try below

 

PrashantSangle_0-1689084440931.png

 

Action > Select values matching search Criteria

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

 

Regards,

Prashant Sangle

 

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
aheavy95
Creator
Creator
Author

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

aheavy95_0-1689085074005.png

 

rbartley
Specialist II
Specialist II

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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂