topic Re: QlikView expression not working in Qlik Sense in App Development

QlikView expression not working in Qlik Sense

anriretief — Mon, 28 Jan 2019 10:15:43 GMT

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

Re: QlikView expression not working in Qlik Sense

ryo_okabe — Mon, 28 Jan 2019 10:32:31 GMT

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)

Re: QlikView expression not working in Qlik Sense

anriretief — Mon, 28 Jan 2019 13:14:11 GMT

Thank you!