topic Simple issue with set analysis in QlikView

Simple issue with set analysis

Fri, 15 Jun 2012 13:21:45 GMT

sum({$<LinkYear3={$(=$(vCurrentFiscalYear))}

right(LinkMonth3,3)={$(=$(vCurrentFiscalMonth))}

>}ATD)

In the set analysis above, I get the appropriate answer when I don't include the middlle month line, but I don't get any value when I include it. For some reason it doesn't work even thought they both have the 3 letter capitalized abbreviation for month for the variable and the right trimmed field.

Re: Simple issue with set analysis

CELAMBARASAN — Fri, 15 Jun 2012 17:38:45 GMT

Hi,

Your not allowed to use right(LinkMonth3,3) as a fieldname to compare in set analysis.

To solve you problem go with wildcard match like below

sum({$<LinkYear3={$(=$(vCurrentFiscalYear))}

LinkMonth3={"*$(vCurrentFiscalMonth)"}

>}ATD)

here * is used for zero or more chars before it.