topic Re: set analysis small exp in QlikView

set analysis small exp

prabhas277 — Fri, 12 Dec 2014 05:45:26 GMT

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

Re: set analysis small exp

jyothish8807 — Fri, 12 Dec 2014 05:54:39 GMT

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

Re: set analysis small exp

amit_saini — Fri, 12 Dec 2014 05:59:39 GMT

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

Re: set analysis small exp

prabhas277 — Fri, 12 Dec 2014 06:01:16 GMT

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

Re: set analysis small exp

prabhas277 — Fri, 12 Dec 2014 06:02:26 GMT

i know this concept yar

pls expain me above expressions .....

Re: set analysis small exp

amit_saini — Fri, 12 Dec 2014 06:05:48 GMT

I think I have explained you this in examples.

Thanks,

Re: set analysis small exp

jyothish8807 — Fri, 12 Dec 2014 06:09:43 GMT

Hi Prabhas,

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

Regards

Re: set analysis small exp

prabhas277 — Fri, 12 Dec 2014 06:17:47 GMT

Thanks Jyothish kc

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

Thanks in Advance

Re: set analysis small exp

jyothish8807 — Fri, 12 Dec 2014 06:18:15 GMT

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

Re: set analysis small exp

jyothish8807 — Fri, 12 Dec 2014 06:20:15 GMT

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

Re: set analysis small exp

Anonymous — Fri, 12 Dec 2014 06:30:16 GMT

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

Re: set analysis small exp

tresB — Fri, 12 Dec 2014 06:31:52 GMT

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