topic Re: Labels from expressions on X-Axis in QlikView

Labels from expressions on X-Axis

zagzebski — Mon, 20 Apr 2015 00:56:27 GMT

This should be real simple but I don't see how to do it. I have a bar chart with no dimensions, only expressions.

I want to put the name of the label I give each expression on the X axis under its respective bar. I don't see how to do this. If I choose "Text on Axis" in the Properties Expressions tab it just puts the data value of the expression on the X Axis not the label. Any ideas how to get the name (label) under the bar?

Thanks in advance for any help!

Steve

Re: Labels from expressions on X-Axis

rwunderlich — Mon, 20 Apr 2015 02:40:00 GMT

It should work as long as you turn off the legend in Presentation. If it doesn't work for you, can you post a QVW?

See my attached example.

-Rob

Re: Labels from expressions on X-Axis

jagan — Mon, 20 Apr 2015 03:11:38 GMT

Hi,

Try like this

Chart Properties -> Presentation -> Uncheck Show Legend option.

Or you can create a Synthetic dimension try like this

Create calculated dimenison in Dimension tab

=ValueList('Test1', 'Test2')

and try below expression

=If(ValueList('Test1', 'Test2') = 'Test1', Sum(Exp1), Sum(Exp2))

Regards,

Jagan.