Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How do I do this stacked bar chart

Hi all

I am not sure how to do a graph like below, it's pretty easy to do it in Excel.  What do I need to do, change the format of data? add some formula in QlikSense? use extension?  so that I can do the stacked bar chart like I want.  Thanks in advanced.

My data are like:

                Sales, Expenses, Profit

Product 1  40, 20, 10

Product 2  30, 10, 15

Product 3  50, 5, 45

etc.

Phyllis

Graph.JPG

1 Reply
Highlighted
Partner
Partner

Re: How do I do this stacked bar chart

Hi Phyllis,

If you do a crosstable Load of that data, and then in the front end, you can just add two dimensions to the graph, and your value as a measure, it should appear as above.

I.e.:

CrossTable(Type, Product)

LOAD F1,

     Sales,

     Expenses,

     Profit

FROM

INPUT FILE....

You can find more information regarding crosstable here:

CrossTable Load in Qlikview-Source

Hope this helps,

Shun