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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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.