topic Re: If to count excluded values (Set Analysis) in QlikView

If to count excluded values (Set Analysis)

cristian_av — Wed, 03 Sep 2014 15:00:37 GMT

I have two field:

Corrected_ID

What I want is:

a) Select All Values from ID

b) Select Excluded Values from Corrected_ID

c) Count all this values (And use this number in a If)

I'm doing that actually using actions, but I need to use that count inside a if, and with actions I think it is not possible.

How can I get that count with some Set Analysis Expression??

Re: If to count excluded values (Set Analysis)

maxgro — Wed, 03 Sep 2014 15:59:58 GMT

maybe

GetExcludedCount(Corrected_ID)

can help you

Re: If to count excluded values (Set Analysis)

ecolomer — Wed, 03 Sep 2014 16:12:52 GMT

You can use this functions:

- GetCurrentSelections (...)

- GetFieldSelections (...)

- GetSelectedCount (...)

- GetPossibleCount (...)

- GetExcludedCount (...)

nad more ....

Re: If to count excluded values (Set Analysis)

cristian_av — Wed, 03 Sep 2014 19:15:04 GMT

But all the functions you both give me, don't accept any kind of SetAnalysis, So for using that functions I will have to select manually the ID Values.

Is there any other way so I can force an expression to consider the count of excluded values of Corrected_ID, But without having to do a selection in the ID field?

I just need the count of excluded values, and I don't want to change the current selection for the user.

Re: If to count excluded values (Set Analysis)

cristian_av — Wed, 03 Sep 2014 20:33:53 GMT

Finally I solved with this Set Expression:

=Count({1-1<Corrected_ID={"**"}>} DISTINCT ID)

Re: If to count excluded values (Set Analysis)

mseeck75 — Wed, 03 Sep 2014 20:48:28 GMT

Hi Cristian,

without any knowledge about the structure of your fields (e.g. both fields in one table or different tables, how to linked etc.) I would suggest to use these expression

=count( {1-$} Corrected_ID)

You can further refine this expression to your requirements.

Hope that helps.

Matthias