QlikView Expression Issue

[#1]

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)

*/

[sunny_talwar · Accepted solution]

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)

*/

[sunny_talwar]

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)

[#4]

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