topic Re: Bar chart in QlikView

Bar chart

viveksingh — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have a table like below

Customer	0 to 30	30 to 60	60 to 90
C1	10	20	30
C2	100	160	210
C3	150	120	110

I want a bar chart which should show sum of all Customers(C1,C2,C3) under 0to30, 30to60, 60to90.

which is C1,C2,C3 under 0to30 is 260

C1,C2,C3 under 30to60 is 300

C1,C2,C3 under 60to90 is 350

I want to show like below

MK_QSL — Mon, 03 Apr 2017 08:16:54 GMT

Use crosstable load..

CrossTable (Flag,Value)

Data:

LOAD Customer,

[0 to 30],

[30 to 60],

[60 to 90]

FROM

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

Now create a bar chart

Dimension

Flag

Expression

SUM(Value)

viveksingh — Mon, 03 Apr 2017 09:10:20 GMT

Thanks Manish