topic Re: Set Analysis Syntax with greater than and less nested in QlikView

Set Analysis Syntax with greater than and less nested

jonathanrichey — Sat, 16 Nov 2024 05:02:30 GMT

I am working on a set analysis expression and it seams I have the logic reversed. I would like my chart to show data only within the last two years.

Where should the greater than or less than operators be used within the equation?

count({<MonthYear ={">=$(=Date(AddYear(MonthYear, -2), 'MMM YYYY'))"}>}ID)

Re: Set Analysis Syntax with greater than and less nested

avkeep01 — Thu, 06 Dec 2018 14:05:40 GMT

Hi @jonathanrichey,

The ' aren't working. You could use this. You only need to make sure that the field Date has the same format as the default date settings at the beginning of your script.

=count({<Date ={">=$(=Date(AddYear(MonthYear, -2)))"}>}ID)

Re: Set Analysis Syntax with greater than and less nested

jonathanrichey — Thu, 06 Dec 2018 14:30:39 GMT

Thanks for the quick response @avkeep01 !

My date is set to=

SET DateFormat='M/D/YYYY';

Currently I have MonthYear as my dimension. I am not sure what is calculating when using the updated expression (see MonthYear.png.

If I change my dimension to Date vs MonthYear my data displays only November and December 2015 (Date.png).

Re: Set Analysis Syntax with greater than and less nested

sunny_talwar — Thu, 06 Dec 2018 14:35:06 GMT

May be you need this

Count({<MonthYear = {">=$(=Date(AddYears(Max(MonthYear), -2), 'MMM YYYY'))"}>} ID)

UPDATE: fixed the function name to AddYears based on Omar's response below

Re: Set Analysis Syntax with greater than and less nested

OmarBenSalem — Thu, 06 Dec 2018 14:32:56 GMT

Your logic is correct; but instead, use AddYearS not addyear

Re: Set Analysis Syntax with greater than and less nested

sunny_talwar — Thu, 06 Dec 2018 14:35:23 GMT

Or this

Count({<MonthYear = {">=$(=Date(AddYears(Today(), -2), 'MMM YYYY'))"}>} ID)

UPDATE: fixed the function name to AddYears based on Omar's response below

Re: Set Analysis Syntax with greater than and less nested

sunny_talwar — Thu, 06 Dec 2018 14:34:25 GMT

Good catch 🙂

Re: Set Analysis Syntax with greater than and less nested

jonathanrichey — Thu, 06 Dec 2018 14:56:23 GMT

This works as well.Thanks for the responses!!