topic Re: Set Analysis not equal in QlikView

Set Analysis not equal

segerchr — Mon, 04 Apr 2016 11:07:02 GMT

Hey,

the option -= does not work in my example. Can anyone help me ?

count({1<Art={'Training'},Urlaub-={'x'}>}SpielerID)/count(Total Distinct SpielerID)

The code for = does work.

count({1<Art={'Training'},Urlaub={'x'}>}SpielerID)/count(Total Distinct SpielerID).

BR. CS

Re: Set Analysis not equal

swuehl — Mon, 04 Apr 2016 12:40:25 GMT

Not really sure what your expected result is, but Urlaub shows only one value 'x', so there are no other values to use in the set when using -=

You could use the e() funcion on a key field, assuming SpielerID is an appropriate field for that:

=count({1<Art={'Training'},SpielerID =e({<Urlaub={'x'}>})>} SpielerID) /count(Total Distinct SpielerID)

Re: Set Analysis not equal

segerchr — Mon, 04 Apr 2016 13:02:43 GMT

My exprected result is: 23

The formel should only count SpielerIDs where not Urlaub=x

Thanks for answering.

Re: Set Analysis not equal

swuehl — Mon, 04 Apr 2016 13:34:55 GMT

Well, I do get 22 with

=count({1<Art={'Training'},SpielerID =e({<Urlaub={'x'}>})>} SpielerID)

Re: Set Analysis not equal

segerchr — Mon, 04 Apr 2016 13:43:12 GMT

Hi,

thats right. 22 ist the correct answer.

Thanks for help.

I should learn the difference between -= and e.

BR CS

Re: Set Analysis not equal

swuehl — Mon, 04 Apr 2016 13:54:31 GMT

Here you are:

Excluding values in Set Analysis

Re: Set Analysis not equal

segerchr — Mon, 04 Apr 2016 15:12:13 GMT

Sorry but i have to ask again. When i multiple the appointments the chartlinie are similar.

My target is to show on:

15.02.2016 --> 22

16.02.2016 --> 21

18.02.2016 --> 23

The data further in percent.

Re: Set Analysis not equal

swuehl — Mon, 04 Apr 2016 15:28:23 GMT

Du musst den richtigen Schüssel für die Set Analysis nehmen, ich habe mal einen im Skript erzeugt, aus TerminID und SpielerID

AutoNumber(TerminID& SpielerID) as KEY

Dann

=count({1<Art={'Training'},KEY =e({<Urlaub={'x'}>})>} DISTINCT SpielerID)

Re: Set Analysis not equal

segerchr — Tue, 05 Apr 2016 06:32:15 GMT

Hi,

thanks a lot it works. But, can you explain it ?

Why do i need the key ? Because when i set the analysis on the SpielerID the SpielerID is not unique ?

Re: Set Analysis not equal

segerchr — Tue, 05 Apr 2016 09:08:53 GMT

Adopted, that i would also exclude verletzt=x and krank=x in the example.

How can I write that ?

Re: Set Analysis not equal

swuehl — Tue, 05 Apr 2016 17:41:48 GMT

Well, it depends if you want to use OR or AND logic to combine your conditions:

=count({1<Art={'Training'},KEY =e({<Urlaub={'x'}>+<verletzt = {'x'}>+<krank = {'x'}>}) >} DISTINCT SpielerID)

=count({1<Art={'Training'},KEY =e({<Urlaub={'x'}, verletzt = {'x'}, krank = {'x'}>}) >} DISTINCT SpielerID)

Re: Set Analysis not equal

segerchr — Wed, 06 Apr 2016 06:50:54 GMT

Thanks so much. It works fine