Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
warrentk80
Creator
Creator

major operator on Analysis set

Good morning at all, I would need to use the largest operator in a Set Analysis formula.

currently using the code in the formula

{$ <[Last Released DV] = {'$ (= vL.AnnoRif)'}>}

where month vL.AnnoRif is equal to 2017.

Everything works regularly, but now I need to consider more data than 2017.

would anyone tell me the sinks to use?

thanks to everyone for the collaboration

Andrew

4 Replies
sergio0592
Specialist III
Specialist III

Hi,

What do you mean when say  'I need to consider more data than 2017.??

You want data between eg.  2015 and 2017 or 2017 to 2018?

warrentk80
Creator
Creator
Author

I mean later years, I could use 2017, 2018 etcc, but I prefer to use the command> also to understand in the Analisys set as it does.

sergio0592
Specialist III
Specialist III

Ok, try with :

{$ <[Last Released DV] = {">=$ (=vL.AnnoRif)"}>}

Colin-Albert

There is a clear explanation of the Set Analysis syntax here

A Primer on Set Analysis