topic Synchronize block height in block chart in QlikView

Synchronize block height in block chart

Tue, 17 Jan 2012 15:43:42 GMT

Is it possible to "straighten" a certain formula in a block chart to 100% to visualize the percentage between two formulas?

See attaced pictures - number 1 ist what I realized in QV so far, and number 2 is what I need.

The formulas are simply two sum()-formulas - budget should always be 100 %.

Thanks in advance!

Re: Synchronize block height in block chart

swuehl — Tue, 17 Jan 2012 15:58:00 GMT

Eva,

I would use a percentage scale for my bar chart then.

Try to set 100% to your budget for each dimension value. If you absolutely need to display also total values, you could create a second expression, and remove the bar tick from the display options, select Value on data points instead.

Please see attached.

The exact syntax for the expression is depending on your data model, if you post some more information on that or a best a small sample app, I could help with that too.

Regards,

Stefan

Re: Synchronize block height in block chart

mkirchhofer — Tue, 17 Jan 2012 16:57:36 GMT

Hi Eva,

maybe not exactly what you need but hopefully useful.

For me the visual effect isn't correct, to see two different Budget values with the same bar height.

best regards

Mario

Synchronize block height in block chart

Wed, 18 Jan 2012 10:55:14 GMT

Hi Mario,

thanks for your reply - indeed, this is almost exactly what we need. I tried it before as bar chart, but this did not work 😉

Do you see any chance to get the total values displayed on the value bars? I played around with it, but couldnt get it to work.

You are right, that the visual effect could be confusing. But this layout is what the customers wants, because they are used to it.

Regards,

Eva

Re: Synchronize block height in block chart

mkirchhofer — Wed, 18 Jan 2012 11:35:00 GMT

Eva_Stein schrieb:
... I played around with it, but couldnt get it to work.

Hi Eva,

me too!

I expect more isn't possible!

regards

Mario