Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cross table help

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.

5 Replies
sunny_talwar

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
Specialist
Specialist

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
Specialist III
Specialist III

More like this Sunny T

Screenshot_2.png

Using your quick solution.

Not applicable
Author

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

miguelbraga
Specialist III
Specialist III

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

Screenshot_3.png

Do you want the groupshowing as a cyclic group?