Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
CELAMBARASAN
Partner - Champion
Partner - Champion

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.

View solution in original post

1 Reply
CELAMBARASAN
Partner - Champion
Partner - Champion

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.