topic Re: Bar Chart Dimension Design in QlikView

Bar Chart Dimension Design

Wed, 16 Oct 2013 09:23:45 GMT

Dear all,

I have the following table. How do i have the customer and contract as horizontal axis? Meaning i want the chart display at the horizontal as below and the bar show on top

AAA-123 AAA-1234 AAA-12345 BBB-332 BBB-3321

Customer	Contract	Cost	Price
AAA	123	5	10
AAA	1234	6	10
AAA	12345	8	10
BBB	332	8	10
BBB	3321	8	10

Re: Bar Chart Dimension Design

swuehl — Wed, 16 Oct 2013 09:28:19 GMT

You can use a calculated dimension:

=Customer & '-' & Contract

and then as expression whatever you want to aggregate:

=only(Cost)

=avg(Price)

or whatever.

Instead of using a calculated dimension (available on dimension tab of chart properties), you can add a field in your load script, that does the same.

Re: Bar Chart Dimension Design

Anonymous — Wed, 16 Oct 2013 09:33:18 GMT

Chee

Create the table as a Chart of type Pivot table, you may well wish to set <Always Fully Expanded> on the presentation tab.

You will need a Calculated Dimension:

[Customer} & '-' & [Contract]

and for expressions

Only(Cost)

Only(Price)

Now comes the fiddly bit

In the GUI drag and drop the Calculated Dimension and drop on one of the expression titles.

Best Regards, Bill

Re: Bar Chart Dimension Design

MayilVahanan — Wed, 16 Oct 2013 09:37:04 GMT

Bring one field from load by Customer & '-' & Contract as CC, and then use as dimension, if you are using in many places.

Re: Bar Chart Dimension Design

Thu, 17 Oct 2013 00:32:52 GMT

hi swuehl,

I have created a calculated dimension as you mentioned. But it seems the dimension is not sorted by customer code.i want all the customer together.