Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Solved

Solved

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

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
MVP
MVP

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
MVP
MVP

Make sense.