Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mg_gsi_da
Contributor III
Contributor III

Using Actions to select upcoming years on a sheet

I try to use the "Actions" function on a sheet to automatically select all future years.

 

It works well with a fixed value but not dynamic. Means the actual year should be evaluated like year(today())

mg_gsi_da_0-1627370044092.png

This works as expected and selects all years >2021

 

I can also set a variable or formula but only for one year

mg_gsi_da_1-1627370515965.png

This would set 2021

 

mg_gsi_da_2-1627370625009.png

This of course doesn't work

 

 

let vGJAHR2 = year(Today())

mg_gsi_da_3-1627371051621.png

Gives 2021 as well. Also =$(vGJAHR2) would result in 2021

 

 

How to modify the expression in the "Action" or the definition of the variable to get alle years selected >the actual year?

Labels (1)
1 Solution

Accepted Solutions
mruehl
Creator III
Creator III

Hi,

Try this: '=Geschäftsjahr>=year(today())'
with simple apostrophes.

Schöne Grüße aus Hesse 😉

View solution in original post

2 Replies
mruehl
Creator III
Creator III

Hi,

Try this: '=Geschäftsjahr>=year(today())'
with simple apostrophes.

Schöne Grüße aus Hesse 😉

View solution in original post

mg_gsi_da
Contributor III
Contributor III
Author

Great. This works.

Die Hesse komme...

 

Danke Gruß Michael