Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to format the bar chart like this.

   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,

expected.JPG

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

It display like this;

myPicture.JPG

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

Thanks a lot,

kechin

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Hi kechin,

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

Hope this helps,

Stefan

View solution in original post

3 Replies
swuehl
MVP
MVP

Hi kechin,

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

Hope this helps,

Stefan

Not applicable
Author

Hi swuehl,

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

chart type.png

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.

Not applicable
Author

Hi swuehl,

I got it,thanks a lot.