topic Re: Bar chart with multiple columns in x axis in QlikView

Bar chart with multiple columns in x axis

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Bar chart with multiple columns in x axis

sunny_talwar — Tue, 27 Sep 2016 16:35:34 GMT

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);

Re: Bar chart with multiple columns in x axis

Mon, 03 Oct 2016 06:34:26 GMT

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.

Re: Bar chart with multiple columns in x axis

sunny_talwar — Mon, 03 Oct 2016 17:42:58 GMT

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