topic Bar Chart Dimension expression doesn't work in QlikView

Bar Chart Dimension expression doesn't work

Mon, 14 Nov 2011 08:50:52 GMT

Hi all,

is it possible to make the dimension of a bar chart bold depending on specific values and how can I do this? The expression in the dimension tab doesn't seem to work and in the font settings of the axis I can only define the whole dimension as bold or not. Multi-coloring doesn't work either. Hmm...

Hope someone can help me.

Regards,

Daniel

Bar Chart Dimension expression doesn't work

swuehl — Mon, 14 Nov 2011 13:33:12 GMT

The manual states:

"When used in tables, the dimension data cells can be

dynamically formatted by means of attribute expressions."

So I don't think this will work for bar chart. You might ask why you are able to set the expressions then, I think this is due to the fact that you could switch between different chart types and the actual displayed chart type just regards the settings it is able to while ignoring others. But I agree this confuses the users and I don't really see an issue why not to format the dimension values for bar chart anyway.

Maybe you could work around this limitation using expression formatting, like formatting the bars themselfes or values / text displayed using values on data points.

Regards,

Stefan

Re: Bar Chart Dimension expression doesn't work

vgutkovsky — Mon, 14 Nov 2011 19:01:05 GMT

Interesting problem...see attached (expand the expressions with the + sign to see how this was done).

Regards,

Vlad

Bar Chart Dimension expression doesn't work

swuehl — Mon, 14 Nov 2011 19:10:53 GMT

Well done Vlad, even much better looking than I had in mind!

Bar Chart Dimension expression doesn't work

johnw — Tue, 15 Nov 2011 01:12:57 GMT

It had never occurred to me to replace dimension legends with an expression set to "text on axis". Clever and simple. I need to remember that one.

Bar Chart Dimension expression doesn't work

Tue, 15 Nov 2011 07:40:49 GMT

This is really cool. Never thought of that solution. Thanks Vlad!

Bar Chart Dimension expression doesn't work

Anonymous — Tue, 15 Nov 2011 08:18:35 GMT

Nice Solution.

Bar Chart Dimension expression doesn't work

IAMDV — Tue, 15 Nov 2011 19:13:00 GMT

Vlad - This very useful technique. thanks for sharing.

Cheers - DV

Bar Chart Dimension expression doesn't work

swarup_malli — Tue, 15 Nov 2011 19:20:04 GMT

Vlad - That was splendid, its a smart solution

Regards

Swarup

Bar Chart Dimension expression doesn't work

Wed, 16 Nov 2011 04:58:59 GMT

hi, vaid

When Legendary Mr. Jhon Wither spoon says outstanding about your work then it is defiantly outstanding. but can u explain that what you done and how it is in bold font.

thanks & regards

Re: Bar Chart Dimension expression doesn't work

swarup_malli — Wed, 16 Nov 2011 13:04:11 GMT

Anil,

Check out the expression in the application, you'll get it when u expand "+" in the expression

Thx