topic Re: Need Set Analysis Explanation in App Development

Need Set Analysis Explanation

dineshraj — Fri, 07 Sep 2018 13:28:08 GMT

Hi all,

I need a clarification on set analysis.

What is the difference between the below two sets?

Sum({$<Item-={"B"}>}Amount)

Sum({$<Item={'*'}-{"B"}>}Amount)

Please Explain this

Thanks in advance.

Regards,

Dineshraj

Re: Need Set Analysis Explanation

sunny_talwar — Fri, 07 Sep 2018 13:33:42 GMT

Let's say you data looks like this

Item Amount

A 50

B 40

Without selection, both the expression will show the same result, i.e. 50. But, the difference comes when you start making selections. For example, let's say you select Item B, Expression 1 in that case will show 0, whereas Expression 2 will continue to show 50. So, in essence, the minus sign before equal continues to honor your selections (and sort of works like an if statement), but the minus sign after = or after {'*'} will disregard all selections made in Item field.

Re: Need Set Analysis Explanation

vunguyenq89 — Fri, 07 Sep 2018 13:39:07 GMT

The former means taking the current selection, then deselect "B" in field Item.

The latter means selecting everything in field Item (regardless of current selection) except for "B".

Re: Need Set Analysis Explanation

dineshraj — Fri, 07 Sep 2018 13:42:46 GMT

Hi Sunny,

Thank you for your Explanation.

Regards,

Dineshraj