set analysis small exp

[prabhas277]

Hi

sum({1-$<Names+={"ravi"}>}sales)             ------For this exp current selection is excluded so fine but i am unable to see ravi also in my chart

sum({1-$<Names-={"ravi"}>}sales)             ------For this exp current selection is excluded so fine but i am able to see ravi  in my chart

so what is  the diff b/w  these two exp? give the explanation for this ..?

Thanks in advance

[jyothish8807]

Hi Prabhas,

In your first expression you are removing "ravi" form the entire set {1} and since += is used the filter applies to "Ravi".

In second expression since you are using -= , so "Ravi is excluded from the entire set and is not getting removed form {1} entire set so you can see the name ravi.

Hope it helps.

Regards

KC

[amit_saini]

Hi Prabhas,

See below:

<Dimension += another set>: add the set to the current selection

<Dimension -= another set>: remove the set from the current selection

Ex: All MANUFACTURERs of the selection + those whose name begins with ENT

{<MANUFACTURER_LDESC += {"ENT*"}>}

Ex: All MANUFACTURERs of the selection except those whose name begins with ENT

{<MANUFACTURER_LDESC -= {"ENT*"}>}

Thanks,
AS

[prabhas277]

Thanks for sharp reply

can u explain me how it works

in the first expression how it remove ravi

names+=ravi means    names=names+ravi   ( i am adding here)  i dont understand removing means here

pls explain above expression in clear

[prabhas277]

i know this concept  yar

pls expain me above expressions  .....

[amit_saini]

I think I have explained you this in examples.

Thanks,

AS

[jyothish8807]

Hi Prabhas,

+= Ravi mean adding ravi to current selection and by doing 1 - $<Name +=Ravi means you are removing Ravi from entire set.

Regards

KC

[prabhas277]

Thanks Jyothish kc

1 - $<Name -=Ravi    .. for this exp It means adding ravi to entire set..Is it correct or not?

Thanks in Advance

[jyothish8807]

In 1st expression by default no name will come and when ever you select any name that name and Ravi will not appear.

In second expression by default Ravi will be appear and apart from your selection all the Names will come.

PFA

Regards

KC

[jyothish8807 · Accepted solution]

Yes, You are removing all Name from entire set of name but not "Ravi" so Ravi's name will always appear what ever selection you will do.

Regards

KC