topic How count in the greyed selection in QlikView

How count in the greyed selection

Tue, 05 Jun 2012 10:57:28 GMT

Hello,

I have a question: how to count in the grey selection:

For instance, i have a field and i want to count how many are on the white field

( for this no problem i use =count( distinct Field) )

but how many are on the grey selection?

I try count( distinct (1-$) Field) but this is not good (because don't want to reverse the all selection,just reverse the selection in a chosen field)

Someone have a idea?

Thanks

Re: How count in the greyed selection

jonathandienst — Tue, 05 Jun 2012 11:01:55 GMT

I think you need =GetExcludedCount(Field).

Hope that helps

Jonathan

How count in the greyed selection

Tue, 05 Jun 2012 11:15:18 GMT

Thx Jonathan,

Butif i want to add filters in the count can i with this fonction?

I give you a simple example but i want to use the count with others conditions like <{ }>.

Do you have another idea?

Re: How count in the greyed selection

jonathandienst — Tue, 05 Jun 2012 11:34:26 GMT

Either you want to count the excluded (grey) values or you want to count vlaues based on a filter. These are two different requirements and they would be met differently.

The excluded count will respect the selections you make in any fields that affect the field that you are counting.

Regards

Jonathan

Re: How count in the greyed selection (ignore the selection)

Tue, 05 Jun 2012 13:17:15 GMT

I will be more specific:

I have an expression witch count in the current selection,

but I want to count this in the opposite selection (or ignore the selection or ignore the selection in a choosen field)

my expresion is =count( Distinct <{Field1={"5"}> Field1).

Do you have an idea how to count how many time "5" appear in the grey selection?

Or how many time "5" appear in the field

independently another field (for instance Field 2):

I try count( Distinct (1-$)<{Field1={"5"}> Field1) and

count( Distinct <{Field1={"5"}>*<{Field2=}> Field1)

but this is not the result I expect.

Thanks for your time and patience.

How count in the greyed selection

swuehl — Tue, 05 Jun 2012 13:36:36 GMT

I haven't fully understood what you are trying to achieve yet, maybe a small sample file or some sample data with your expected outcome might help.

Please check the Help file, in the set analysis section, you find a description of using set analysis with implicite field value definitions, namely the e() function. I assume that's what you are looking for.

Re: How count in the greyed selection (ignore the selection)

Tue, 05 Jun 2012 13:46:49 GMT

count( Distinct <{Field1={"5"},{Field2=}> Field1) i find this in another discution

This is what i want.

http://community.qlik.com/message/115823#115823

Re: How count in the greyed selection (ignore the selection)

swuehl — Tue, 05 Jun 2012 13:53:17 GMT

Ok, if this it what you want, good to hear that you found a solution.

But I believe this syntax does not 'reverse the selection in a chosen field' as required above.

It is clearing the selection in one field in the context of the set expression.

But maybe I am still misunderstanding what you are trying to achieve.

Regards,

Stefan

Re: How count in the greyed selection (ignore the selection)

Wed, 06 Jun 2012 10:18:46 GMT

Hi stefan

Yes this expression dont reverse the selection but we can make a subtraction:

count( Distinct <{Field1={"5"},{Field2=}> Field1) -count( Distinct <{Field1={"5"}> Field1)

Thanks