Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
materi
New Contributor III

Sum SET expression doesn't work.

Hi everyone! Can anyone please tell me why the following expression doesn't work:

Sum({$<A={'x'},B={$(vMonth)}>}C) - Sum({$<A={'x'},B={$(vMonth)}>}D)

Each of the Sum({$<A={'x'},B={$(vMonth)}>}C) expressions work independently, but the minus operation doesn't do anything. What am I missing? I'm pretty sure this is the correct syntax to use for this operation, and I get no error messages. The result I get is that the last Sum expression isn't counted and it's as if only the first Sum expression exists.

1 Solution

Accepted Solutions
materi
New Contributor III

Re: Sum SET expression doesn't work.

Thanks but I solved it! 🙂

View solution in original post

4 Replies
MVP
MVP

Re: Sum SET expression doesn't work.

Which object are you using this expression in? Does it work in a kpi object?

materi
New Contributor III

Re: Sum SET expression doesn't work.

Yes, but I've also tried it in a table with the same result. I also set the displaying options of the value to use 9 decimals, so I don't think the size is an issue either.

MVP
MVP

Re: Sum SET expression doesn't work.

I meant it for different granularity but size. Could you share a sample app to have a look ?

materi
New Contributor III

Re: Sum SET expression doesn't work.

Thanks but I solved it! 🙂

View solution in original post