topic Re: Combo chart and pivot table in QlikView

Combo chart and pivot table

Wed, 13 Feb 2013 21:39:47 GMT

Hi,

I have combo chart Offshore and pivot table Clusters (see pic).

I need to resolve two issues:

1) in combo chart display bar expression Offshore like min and max range. Y axe scale have to stay 0-100%. Its possible? How?

2) If I scroll chart and pivot table for other values, i need to scroll both object at some time. Values in pivot table have to response to values in combo chart (columns bellow) I'm not sure if it is possible.

Eventually how can i put the expression from pivot table to combo chart?

Thanks for any help.

Re: Combo chart and pivot table

vivientexier — Wed, 13 Feb 2013 21:48:53 GMT

For your first question : yes, it is possible.

Go on your chart properties, select the "Axes" tab ; on the top-right corner : check "Static min" and add "0" as a value, check "Static max" and add "1" as a value

Re: Combo chart and pivot table

vivientexier — Wed, 13 Feb 2013 21:52:20 GMT

I think the answer to your second question is : not possible.

Re: Combo chart and pivot table

Wed, 13 Feb 2013 22:09:00 GMT

thanks fo reply, but i need to expression display like min and max range.

I painted it to the new pic🙂

Re: Combo chart and pivot table

shree909 — Wed, 13 Feb 2013 22:12:00 GMT

i think when u expand the + sign of the expression

u fwill find a option show values..

in that specify the expression to show the max and min values whihc will be shown on the bAR...

but i doubt that we can show both the max and min values....

Re: Combo chart and pivot table

vivientexier — Wed, 13 Feb 2013 22:14:46 GMT

Ok, I see what you mean.

Go to your chart properties, then on "Espressions" tab. Click on "+" of your expression. One of the available option is "Bar offset" (where your bar will start - add your "Min value"). Then the value of your expression should be ("Max value" - " Min value"). That's all

Re: Combo chart and pivot table

vivientexier — Mon, 18 Feb 2013 14:17:43 GMT

Does this solves your problem?

If yes kindly close the post by marking it answered.