topic QlikView Expression Issue in QlikView

QlikView Expression Issue

Wed, 25 Nov 2020 16:16:04 GMT

The following two expressions were run in a chart pivot table. The first one does NOT work. It produces a result nearly twice as high as it should. If I swap it out for the commented version, everything works correctly. I don't know the difference and I didn't see any difference in a hex editor either. What is QlikView seeing that I'm not?

Sum ({$<

[LinkId]={"PRD"},

[DeptId] = {'300'},

OperationID = {110000,100000,120000},

WorkCenterDesc -= {'Adm*', 'Qua*'}

ProductionTranHours)

Sum ({$<

[LinkId]={"PRD"},

[DeptId] = {'300'},

OperationId = {110000,100000,120000},

WorkCenterDesc -= {'Adm*', 'Qua*'}

ProductionTranHours)

Re: QlikView Expression Issue

sunny_talwar — Fri, 03 Jun 2016 18:34:28 GMT

I see one difference

Sum ({$<

[LinkId]={"PRD"},

[DeptId] = {'300'},

OperationID = {110000,100000,120000},

WorkCenterDesc -= {'Adm*', 'Qua*'}

ProductionTranHours)

Sum ({$<

[LinkId]={"PRD"},

[DeptId] = {'300'},

OperationId = {110000,100000,120000},

WorkCenterDesc -= {'Adm*', 'Qua*'}

ProductionTranHours)

Re: QlikView Expression Issue

sunny_talwar — Fri, 03 Jun 2016 18:40:02 GMT

QlikView and Qlik Sense are case sensitive and OperationID is different then OperationId. Expression editor might not have showed any error, but whichever is wrong will not consider the set analysis (which my guess is the first one in your case)

Re: QlikView Expression Issue

Fri, 03 Jun 2016 18:41:27 GMT

That did it! Well I’m a Newbie but I missed it here and in the text editor…that’s not even up to Newbie ☹

Thank you! cdm