topic Bar Chart Dim / Expr. swap in QlikView

Bar Chart Dim / Expr. swap

Wed, 06 Feb 2013 08:42:00 GMT

Hi,

I have a chart (attached below) called Current Chart. I need the Dim and Expr. swapped. The Chart I need is also attached below called result.

I have tried putting the expr. as a calculated dim but that does not seem to work.

Can anyone help?

Thanx in advance.

Re: Bar Chart Dim / Expr. swap

Thu, 07 Feb 2013 09:31:04 GMT

Maybe I must put my question in a diffrent way.

I have the below table ( Straight table)

Category	Usage 4 weeks	Usage 12 weeks	Usage 52 weeks
Beer Overall Water Usage Ratio	0.00	0.72	1.35
Overall Water Usage Ratio	0.00	1.00	2.87
SSD Overall Water Usage Ratio	0.00	0.00	0.05

I took this table and converted it into a pivot and moved the Cateory below the three expressions that looked like this:

	Usage 4 weeks			Usage 12 weeks			Usage 52 weeks
Category	Beer Overall Water Usage Ratio	Overall Water Usage Ratio	SSD Overall Water Usage Ratio	Beer Overall Water Usage Ratio	Overall Water Usage Ratio	SSD Overall Water Usage Ratio	Beer Overall Water Usage Ratio	Overall Water Usage Ratio	SSD Overall Water Usage Ratio
	0.00	0.00	0.00	0.72	1.00	0.00	1.35	2.87	0.05

Now my graph should look exactly like this. A bar for the 4 Week period but stacked by the categories and the same for the 12 and 52 weeks

Re: Bar Chart Dim / Expr. swap

Gysbert_Wassenaar — Thu, 07 Feb 2013 12:10:46 GMT

You'll have to do a bit of trickery with a calculated dimension using valuelist and a nested if or pick-match combo in the expression. See attached qvw for an example.

Re: Bar Chart Dim / Expr. swap

Mon, 11 Feb 2013 05:25:32 GMT

Hi Gysbert.

Thanx a million for your help. This is exactly what I need. I will modify and insert it into my model.