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

[Anonymous]

Hi Prabhas,

In first expression your are adding extra name "ravi" in current set and then you are using 1-$ means in whole set you are removing current set with ravi name also, So  you are not able to see Ravi in your chart.

But in second expression you extract Ravi from Names and then you are using 1-$ means current selection is excluded but still Ravi would be in your chart.

Hope It would be helpful for you.

Thanks

[tresesco]

Have a look here, I explained similar: http://community.qlik.com/message/678993#678993