Qlik Community

Qlik Sense App Development

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

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
Highlighted
materi
New Contributor III

Re: Sum SET expression doesn't work.

Thanks but I solved it! 🙂

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 ?

Highlighted
materi
New Contributor III

Re: Sum SET expression doesn't work.

Thanks but I solved it! 🙂