Bar chart with multiple columns in x axis

[#1]

Dear All,

For below data I wanted to create a Bar(stack also) chart with all expenses in X-Axis and count of it in Y-Axis. and also wanted to do some filter on other columns like By Family or by gender. my data is in excel.

Family	member	gender	food	transport	misc	health
A	A1	M	MEDIUM	HIGH	LOW	NIL
A	A2	F	LOW	LOW	NIL	MEDIUM
B	B1	M	MEDIUM	MEDIUM	HIGH	MEDIUM
B	B2	M	LOW	NIL	HIGH	MEDIUM
C	C1	F	NIL	MEDIUM	NIL	LOW

PFA, expected sample result.

[sunny_talwar · Accepted solution]

May be use a The Crosstable Load

Table:

CrossTable(Type, Rating, 3)

LOAD Family,

    member,

    gender,

    food,

    transport,

    misc,

    health

FROM

[https://community.qlik.com/thread/234334]

(html, codepage is 1252, embedded labels, table is @1);

[#3]

Sorry for late reply. Thanks sunny for your solution. When I tried cross table with original data, it is not giving the correct output rows. I was expected around 14K rows but it is giving around 300 rows less.

[sunny_talwar]

Would you be able to share your application to see the issue?