concat in set analysis doesn't work

[wanyunyang]

Hi guys,

I have below formula with set analysis, but it returns null value:

Sum({<[Year]={"$(=concat(distinct [Year]-2, ', '))"}>}Qty)

Does anyone have any idea where the issue is? Thanks in advance!

[Oleg_Troyansky · Accepted solution]

Hi,

The double quotes inside your Set Analysis values presume Search, however the concatenated list of years doesn't contain any search conditions. I think it should work better without double quotes.

I'd also challenge the condition itself. Perhaps a search for the year that's greater then the current year - 2, would be more logical?

If you want to learn more about Set Analysis, AGGR(), and other advanced development techniques, join us at the Masters Summit for Qlik in New Orleans on November 14-16.

Cheers,

[Fernando_Fabregas]

Hi ! Did you try to eliminate double quotation marks ?

[wanyunyang]

Hi Oleg,

Thank you for your reply. The formula is to see previous two year's number based on the selection, so I'm using Year-2.

The issue is the double quote. After I removed it, the formula worked fine. Thank you!