topic Re. :Re: Re. :Multiple Field Selections Set Analysis in QlikView

Multiple Field Selections Set Analysis

Mon, 07 Jun 2010 20:51:47 GMT

Set Analysis trouble doesn't seem to be anything new... but I can't find any old posts that address my issue...

I'm attempting to show a total count of surveys regardless of 3 possible selections. The user can select the question text, question ID, and question category. I would like these three selections to be excluded in the set analysis. Selections like date, location, etc. can remain. I essentially need to combine the following into one set analysis:

COUNT

({$<AvatarQuestionCategoryNM = >} PatientSurveyID)

COUNT({$<QuestionTXT = >} PatientSurveyID)

COUNT({$<QuestionID= >} PatientSurveyID)

Thanks in advance!

Re. :Multiple Field Selections Set Analysis

martin59 — Mon, 07 Jun 2010 21:00:32 GMT

Hi,

Is that you want ?

Count({<AvatarQuestionCategoryNM={"$(=Only(AvatarQuestionCategoryNM))"}, QuestionTXT={"$(=Only(QuestionTXT))"}, QuestionID={"$(=Only(QuestionID))"}>} PatientSurveyID)

Re. :Multiple Field Selections Set Analysis

Mon, 07 Jun 2010 21:09:27 GMT

That doesn't do it - I do not want the count to be affected by any of those 3 potential selections.

Re. :Re: Re. :Multiple Field Selections Set Analysis

martin59 — Mon, 07 Jun 2010 21:19:14 GMT

<pre>Count({$-(<AvatarQuestionCategoryNM={"$(=Only(AvatarQuestionCategoryNM))"}>+<QuestionTXT={"$(=Only(QuestionTXT))"}>+<QuestionID={"$(=Only(QuestionID))"})>} PatientSurveyID)

Re. :Re: Re. :Multiple Field Selections Set Analysis

Mon, 07 Jun 2010 21:35:30 GMT

That's just bringing back NULL in the cell now... This seems closer, I get taking the current selections excluding the set, but I don't think the union of those 3 works?

Re. :Re: Re. :Multiple Field Selections Set Analysis

Tue, 08 Jun 2010 00:02:08 GMT

I'm not sure why Martin out the 'only' key word in his suggestions. I believe his set is otherwise correct. (just eyeballing), but using the word 'only' he doesn't make sense.

take out all of the 'only' keywords in that set, and you may be in business.

Re. :Re: Re. :Multiple Field Selections Set Analysis

Tue, 08 Jun 2010 15:14:40 GMT

This is what I put in and it's still returning NULL.

Count

({$-(<AvatarQuestionCategoryNM={"$(=(AvatarQuestionCategoryNM))"}>+<QuestionTXT={"$(=(QuestionTXT))"}>+<QuestionID={"$(=(QuestionID))"})>} PatientSurveyID)

Re. :Re: Re. :Re: Re. :Multiple Field Selections Set Analysis

martin59 — Wed, 09 Jun 2010 14:54:13 GMT

Try that :

<pre><blockquote><pre>Count({<AvatarQuestionCategoryNM=E(AvatarQuestionCategoryNM)>+<QuestionTXT=E(QuestionTXT)>+<QuestionID=E(QuestionID)>} PatientSurveyID)

I didn't test it.

Re. :Re: Re. :Re: Re. :Multiple Field Selections Set Analysis

Wed, 09 Jun 2010 17:36:04 GMT

Continue to get a NULL value... What do the "E's" mean in this formula??

Multiple Field Selections Set Analysis

Oleg_Troyansky — Wed, 09 Jun 2010 18:06:13 GMT

As a side comment - you seem to be going back and forth with the "dry" formula... It could be much easier if you could post a small working example and everyone could take a stab at resolving it...

Now, let me ask you this - what do you mean when you say:


S-Jenson wrote: I would like these three selections to be excluded in the set analysis.

Do you mean - ignore selections in those three fields? Then the SA expression should be :

{$<Field1=, Field2=, Field3= >}

The above expression will cause ignoring any user selections in the three fields and respecting any other user selections.

If by "exclude" you mean reversing the selection in those three fields, or excluding the selected values from calculation, then you need to use the syntax with E( ...) where E stands for "Excluded values" - something like this:

{$<Field1= E(Field1), Field2=E(Field2), Field3=E(Field3) >}

Be careful, the expression above might be heavy if some of the fields have many distinct values...

I highly recommend printing out the article "Set Analysis" from the Help Section and reading it thoroughly - you will find examples for just about any situation there.

Multiple Field Selections Set Analysis

Wed, 09 Jun 2010 18:32:14 GMT

Ignore selections is what did it. I swear I had tried to use this already...

THANK YOU Everyone!!