What is Show Value attribute in Expression Definition?

[shumailh]

I was trying to explore design options in qlikview, and i found this show value option in expression defination tab. Can anyone tell me what is this?

Shumail

[jonathandienst]

Shumail

It controls the display of the values on the chart (eg above the bar, same as "values on Data Points")

Jonathan

[shumailh]

Can we even change the values like differ from the bar / line ploted value?

Shumail

[#4]

Hi,

I tried this option and entered a definition (eg. sum(population)) which is different from the original expression (sum(Area)) but, am still getting the value of the original expression (sum(population)) instead of the expression (sum(Area)) given in 'show value' property.

I have also unchecked the 'Value on Data Points' option. Can someone explain why the value is not changing. I am a bit confused on how this property works.

- Haneesh

[shumailh]

I tried the same but not working... I think we can only modify the formating of the value on data point.

Shumail

[#6]

Hi,

I think this feature is to display conditional values in chart abov data points.

The way we give expression for background, text etc. in expression, show value can also be condition based.

I tried if condition.

e.g. In a chart displaying name and marks of students, I want to display only those marks above datapoints which are greater than 10 (or whatever value).

But it is not displaying conditional values. It displays all values.

Can somebody try this and let me know?

Thanks,

Happy Thoughts

[jonathandienst]

You can use something like:

if(Column(3) > 500, 1, 0) or (if(someField > 500, 1, 0)

as the condition. I only tested this for the same column, but I can think of no reason that a more complex expression should not work.

Jonathan

[#8]

Here is the definition for this property from the reference manual:

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

Show Value

Only applicable on bar, line and combo charts. Click on

Show Value in order to enter an attribute expression for

calculation whether the data point plot should be complemented

with a "number on data point value", even if Values

on Data Points has not been selected for the main

expression. If Values on Data Points is selected for the

main expression the attribute expression will be disregarded.

I found that this property is to override the default expression values and show alternate values in the bar/line, but, I tested this and it is not working as expected.

Can someone try this and throw some lights.

-Haneesh

[jonathandienst]

I don't think this property allows you to change what displays. It only allows you to turn "Values on data points" on for selected points, based on the true(non zero) or false (zero) value returned from your expression.

Jonathan

[kji]

It is treated like a boolean, non-zero -> Value on datapoint is show. To get some unrelated value to be shown, either use a separate expression with Bar/Line/symbol all unchecked, or use a Dual function for your expression.