Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis last 3 periods

Hello,

I have a file with datas for each 6 months. I want to do an analysis for last 3 periods so for the last 18 months.

Can I do this with set analysis? What is the syntax?

Thanks you,

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

You can do this with Set Analysis, but I would suggest trying simpler (and better) ways first. If you load all your data, and in addition a Master Calendar, you could define a relative month in this calendar: 0 for this month, -1 for last month, etc. All you then need to do is to select month -18 to -1.

See more on Relative Calendar Fields

HIC

View solution in original post

2 Replies
Not applicable
Author

Yes You Have an expression but can you upload your data file?

or

Check This Thread

Relative Calendar Fields

hic
Former Employee
Former Employee

You can do this with Set Analysis, but I would suggest trying simpler (and better) ways first. If you load all your data, and in addition a Master Calendar, you could define a relative month in this calendar: 0 for this month, -1 for last month, etc. All you then need to do is to select month -18 to -1.

See more on Relative Calendar Fields

HIC