Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

how to create per column in graph

Hi all

The data will be like this
1a.png

and shown in bar chart like this2a.png

and the graph that i want is like below3a.png

To make this graph I change the table structure. But it’s not suggested

4a.png

Is it possible to make 2nd graph without changing table structure?

Because I want to compare/analyse  a value for each item, because the 1st chart cannot see the comparison between item.

Any suggestion to solve this?

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: how to create per column in graph

Try

The Crosstable Load

CROSSTABLE (ValueName, Value)

LOAD

    Name,

    "Value 1",

    "Value 2",

    "Value 3"

FROM [lib://book2/Book2.xlsx]

(ooxml, embedded labels, table is Sheet2);

Then you can easily create both charts using either

1) Name

2) ValueName

or

1) ValueName

2) Name

as your two dimensions and

=Sum(Value)

as expression.

2 Replies
MVP
MVP

Re: how to create per column in graph

Try

The Crosstable Load

CROSSTABLE (ValueName, Value)

LOAD

    Name,

    "Value 1",

    "Value 2",

    "Value 3"

FROM [lib://book2/Book2.xlsx]

(ooxml, embedded labels, table is Sheet2);

Then you can easily create both charts using either

1) Name

2) ValueName

or

1) ValueName

2) Name

as your two dimensions and

=Sum(Value)

as expression.

Not applicable

Re: how to create per column in graph

"crosstable" words, give me to next stage

thanks

Community Browser