Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Solved

Solved

1 Solution

Accepted Solutions
sunny_talwar

Just these values? How are they going to be linked to your other database? May be this if this is an Island table

LOAD Year(Today()) - RecNo() + 1 as Year

AutoGenerate 3;

View solution in original post

3 Replies
sunny_talwar

Just these values? How are they going to be linked to your other database? May be this if this is an Island table

LOAD Year(Today()) - RecNo() + 1 as Year

AutoGenerate 3;

microwin88x
Creator III
Creator III
Author

Thanks! It worked. Yes, I'm using those values to keep a field with the years I want to filter in a table with where exists clause in order to get it optimized.

sunny_talwar

Make sense.