topic How to format the bar chart like this. in QlikView

How to format the bar chart like this.

Mon, 07 Nov 2011 10:35:29 GMT

Hi dear friends,

I'm new to Qlikview,when I try to do a bar chart I got some problems,please help me,thank you very much.

I have two fileds: Gender,Product as the dimension

one Expression: COUNT(DISTINCT IF(Type = 'Claims',ClaimsPolicyID,0))/COUNT(DISTINCT [Policy Number])

I try to do the chart like this,

but I attempt a lot of methoms,it cann't meet my requirment,

It display like this;

so I wonder if there are some properites to change the format like the second picture.

Thanks a lot,

kechin

swuehl — Mon, 07 Nov 2011 10:46:58 GMT

Hi kechin,

try a trellis chart (there is an optional dialog available on dimensions tab of your chart properties).

Hope this helps,

Stefan

Tue, 08 Nov 2011 01:39:23 GMT

Hi swuehl,

thanks for you reply,my version is Personal Eidtor 10,all the chart type is below,

and I cann't find the 'trellis chart',so would you please show me which one is the expected one,

this chart is a sample I got from the Qlikview Samples, and the properties display as Bar chart,

if you have any idea about this

thanks

kechin.

Tue, 08 Nov 2011 01:55:26 GMT

Hi swuehl,

I got it,thanks a lot.