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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.