Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Simple issue with set analysis

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. 

1 Solution

Accepted Solutions

Re: Simple issue with set analysis

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.

1 Reply

Re: Simple issue with set analysis

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.

Community Browser