topic Set analysis concept with text in QlikView

Set analysis concept with text

Tue, 22 Oct 2013 15:37:54 GMT

I am over analyzing what I thought was a simple task...

For those of you in healthcare you are probably familiar with Meaningful Use. I have an excel spread sheet that has all the details on the measures for Stage two.

I would like to create an informative tab in my MU Dashboard that lists breaks down the details of each measure. I loaded the excel spread sheet into my load script and now I can't figure out how to use it.

I am trying to use set analysis on text fields and failing miserably...

The concept I would like to use is simple...

sum({<Measure={'P208'}>}Requirements)

The desired result is a blurb in the spread sheet :

Measure

Definition

Requirements

P208

Record demographics

More than 80% of all unique
patients seen by the EP have demographics recorded as structured data.

But I keep getting '0' and I am assuming its because I can't SUM the Requirements....

Any guidance would be greatly appreciated

Re: Set analysis concept with text

Carlos_Reyes — Tue, 22 Oct 2013 15:43:37 GMT

Use MaxString instead of Sum... although perhaps there are more efficient functions to deal with strings but I always use MaxString when I need to get that kind of result.

Re: Set analysis concept with text

Aurelien_Martinez — Tue, 22 Oct 2013 15:44:28 GMT

Hi,

Use Concat or Only like:

Only({<Measure={'P208'}>}Requirements)

Concat({<Measure={'P208'}>}Requirements)

Regards,

Aurélien

Re: Set analysis concept with text

Tue, 22 Oct 2013 15:51:40 GMT

Thanks Carlos, that worked perfectly!