topic Re: major operator on Analysis set in QlikView

major operator on Analysis set

warrentk80 — Thu, 09 Nov 2017 13:21:10 GMT

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

Re: major operator on Analysis set

sergio0592 — Thu, 09 Nov 2017 13:24:21 GMT

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?

Re: major operator on Analysis set

warrentk80 — Thu, 09 Nov 2017 13:29:43 GMT

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.

Re: major operator on Analysis set

sergio0592 — Thu, 09 Nov 2017 13:32:23 GMT

Ok, try with :

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

Re: major operator on Analysis set

Colin-Albert — Thu, 09 Nov 2017 13:54:27 GMT

There is a clear explanation of the Set Analysis syntax here

A Primer on Set Analysis