Bar chart

[viveksingh]

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 · Accepted solution]

Use crosstable load..

CrossTable (Flag,Value)

Data:

LOAD Customer,

     [0 to 30],

     [30 to 60],

     [60 to 90]

FROM

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

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

Now create a bar chart

Dimension

Flag

Expression

SUM(Value)

[viveksingh]

Thanks Manish