topic Re: Set Analysis chart expression overrides selection in chart dimensions in QlikView

Set Analysis chart expression overrides selection in chart dimensions

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone

I am trying to create a big table chart where I list services provided by multiple doctors over the years. The services in the data are grouped into "medication" and "examination". For the time being I'm only interested in medication, so I select and locked that in a listbox. I would, however, like to know how many different patients have been treated by each doctor in each year, regardless of grouping, which is why I employed the following Set Analyses chart expression:

count({<Group={'Examination', 'Medication'}>} TOTAL <DoctorID, Year> Distinct PatientID)

This is supposed to write the total number of treated patients for each doctor in each year onto every row of the table. While the expression does what I want it to, it also messes with my chart. I found that it overrides my Group variable for the other dimensions too, which is not what I want. I want to keep all dimensions locked to Group = Medication and only have the patient-counting variable use the data from the Examination Group as well.

What am I doing wrong?

Thank you in advance

Re: Set Analysis chart expression overrides selection in chart dimensions

dplr-rn — Thu, 13 Sep 2018 16:24:31 GMT

Once you use the set analysis it overrides your selections

count({<Group={'Examination', 'Medication'}>}

so here You are forcing the group to examination and medication.

i feel you will need another approach. maybe aggr?

Re: Set Analysis chart expression overrides selection in chart dimensions

vishsaggi — Thu, 13 Sep 2018 16:39:40 GMT

Not sure i fully understood can you share a sample app to look into and also your expected output you want to see.

TOTAL qualifier respects current selections when used in your expression. So may be try like:

Use Dim:

DoctorID

Year

Expr:

= Count({1<Group={'Examination', 'Medication'}>} Distinct PatientID)

Re: Set Analysis chart expression overrides selection in chart dimensions

Anonymous — Fri, 14 Sep 2018 12:45:48 GMT

I would like for the expression code to ONLY override the selections for the expression column. Is this possible at all?

Re: Set Analysis chart expression overrides selection in chart dimensions

Anonymous — Fri, 14 Sep 2018 12:47:21 GMT

Thank you for the suggestion. Unfortunately, it only gives me a blank table with "out of memory" in the middle.

What I'm after is for a way to only override the selection in my listboxes in the expression field, if that is possible.

Re: Set Analysis chart expression overrides selection in chart dimensions

dplr-rn — Fri, 14 Sep 2018 13:39:49 GMT

not clear what you mean. share a screenshot if possible