topic Re: Cross table help in QlikView

Cross table help

Tue, 19 Jan 2016 13:28:50 GMT

I have excel file like below.

Address ID Physician Nurse Pediatric

ABC 1 5 6 8

DEF 2 6 4 3

GHI 3 5 6 7

I need a bar chart with count for Physician,Nurse and Pediatric.

I have to group Physician,Nurse and Pediatric into one field.How can I do this ?

Thank you very much.

sunny_talwar — Tue, 19 Jan 2016 15:34:31 GMT

This may be?

Table:

CrossTable(Group, Value, 2)

LOAD *;

LOAD * Inline [

Address, ID, Physician, Nurse, Pediatric

ABC, 1, 5, 6, 8

DEF, 2, 6, 4, 3

GHI, 3, 5, 6, 7

];

andrespa — Tue, 19 Jan 2016 15:37:40 GMT

Hi Pavana,

If I understand your requeriment, you should do something like this:

CrossTable(Merge, Data, 2)

LOAD Address,

ID,

Physician,

Nurse,

Pediatric

FROM

(ooxml, embedded labels, table is Hoja1);

That way, you can count by the Merge field.

Hope it helps.

Cheers,

Andrés

miguelbraga — Tue, 19 Jan 2016 15:40:48 GMT

Tue, 19 Jan 2016 15:47:24 GMT

I agree with Andrés. Good idea!!!!

miguelbraga — Tue, 19 Jan 2016 15:56:36 GMT

Or if you want a horizontal stacked bar char like this:

Do you want the groupshowing as a cyclic group?