QlikView expression not working in Qlik Sense

[anriretief]

I converted my QlikView document to Qlik Sense

I have a pivot table in Qlik Sense that is identical to the one in the QlikView dokument

But for some reason the following expression works fine in QlikView but not in Qlik Sense

IF(SUM({<LIDNO-={'',' *'}>}MASSA)<>0,SUM({<LIDNO-={'',' *'},KONTRAKNOMMER={'N*'}>}if(match(LEFT(KONTRAKNOMMER,3),'NPO','NW2','NW1','NW3'),MASSA_VASGEMAAK,MASSA_OOREENGEKOM)),0)

Any help would be appreciated

Thanks in advance

[ryo_okabe · Accepted solution]

Hi,

You should use double quote if you want to use wildcard in set expression.

IF(SUM({<LIDNO-={''," *"}>}MASSA)<>0,SUM({<LIDNO-={''," *"},KONTRAKNOMMER={"N*"}>}if(match(LEFT(KONTRAKNOMMER,3),'NPO','NW2','NW1','NW3'),MASSA_VASGEMAAK,MASSA_OOREENGEKOM)),0)

[anriretief]

Thank you!