topic Re: and in set analysis in QlikView

and in set analysis

Tue, 06 Aug 2013 08:58:22 GMT

Hi everyone,

I weant to count all my costumers where the store has the number 472 AND 740 meaning the costumer has been to both stores how can I do this???

regards,

Re: and in set analysis

MayilVahanan — Tue, 06 Aug 2013 09:02:01 GMT

Try like this

= Count({<Store = {472}> * <Store = {740}>} Customers)

Hope it helps

Re: and in set analysis

Miguel_Angel_Baeyens — Tue, 06 Aug 2013 09:02:48 GMT

Hi,

Try with

Count({< Store *= {740, 472} >} CustomerID)

Count({< Store = {740} > * < Store = {472} >} CustomerID)

Hope that helps.

Miguel

Re: and in set analysis

Tue, 06 Aug 2013 09:12:59 GMT

according to your question, no any use of and operater that is *.

then simply try with or operator.

Count({< Store = {470, 472} >} CustomerID)

or try this

Count({< Store = {'470', '472'} >} CustomerID)

Re: and in set analysis

Miguel_Angel_Baeyens — Tue, 06 Aug 2013 09:18:32 GMT

Hi,

If you want to select both values in the same listbox, you need to use the "*". Otherwise, you are selecting all values in CustomerID that correspond to one or the other values in the right part, but not both at the same time. In this case, you only want those CustomerID that are in both stores, not in either of those.

Hope it makes sense.

Miguel

Re: and in set analysis

Tue, 06 Aug 2013 09:22:55 GMT

i agree sir

Re: and in set analysis

Tue, 06 Aug 2013 10:07:00 GMT

I select one of theses stores and then I want to figure out how many costumers where in both stores not just in one. if i use * i only get 0 and that is defenetly not correct 🙂

Re: and in set analysis

Tue, 06 Aug 2013 12:11:09 GMT

Hi,

ig tried now the * and the + and both is giving me an incorrect result. It is acting like an OR and not like an AND. I select my 2 stores now in the listbox and then i wrote count({< Store = {740} > * < Store = {472} >} CustomerID) and I also tried it with '+'. I mena with acting like an OR that all Costumers are beeing count that have been either in store 472 or 740 and not in both.

please help me on this.

regards,

Re: and in set analysis

Wed, 07 Aug 2013 08:33:40 GMT

count({$<_FILIALE *= {'472','740'}>}_KUNDEN_ID)

I also tried the the formula above. and I never get the right result. Either it is 0 or all costumers will be count.

I would very appriciate if someone could help me it is very important.

regards

Re: and in set analysis

Wed, 07 Aug 2013 08:36:36 GMT

sobasicly waht i need is the intersection of one field