topic Re: Create Bar chart in QlikView

Create Bar chart

Wed, 11 Nov 2015 13:31:58 GMT

Hi,

I need help in creating a bar chart as under

The Db table 'X' the chart is pointing to has following columns:

1) Column 'Cycles' that has values Cycle 1, Cycle 2 etc (it can go upto Cycle 'n')

2) Columns 'P', 'F', 'B'.

On the chart,

X axis to have cycles as separate bars based on the max value in Cycles column

Each cycle bar will have count of 'P', 'F', and 'B'.

What should be the expressions and dimensions for the chart?

Thanks in advance.

swuehl — Wed, 11 Nov 2015 13:54:56 GMT

Try one dimension, Cycles and three expressions:

=Count(P)

=Count(F)

=Count(B)

and set style to stacked in bar properties.

Or use a CROSSTABLE LOAD prefix in your script:

CROSSTABLE (Column, Value)

LOAD Cycles, P,F,B

FROM ...;

Then use dimensions Cycles and Column and as expression

=Count(Value)

Wed, 11 Nov 2015 14:38:23 GMT

Thanks a ton, Swuehl. The first option worked.