topic What is Show Value attribute in Expression Definition? in QlikView

What is Show Value attribute in Expression Definition?

shumailh — Mon, 02 Aug 2010 06:35:54 GMT

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

What is Show Value attribute in Expression Definition?

jonathandienst — Mon, 02 Aug 2010 10:17:52 GMT

Shumail

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

Jonathan

What is Show Value attribute in Expression Definition?

shumailh — Mon, 02 Aug 2010 10:25:14 GMT

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

Shumail

What is Show Value attribute in Expression Definition?

Mon, 02 Aug 2010 10:27:45 GMT

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

What is Show Value attribute in Expression Definition?

shumailh — Mon, 02 Aug 2010 10:36:00 GMT

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

Shumail

What is Show Value attribute in Expression Definition?

Mon, 02 Aug 2010 10:39:43 GMT

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

What is Show Value attribute in Expression Definition?

jonathandienst — Mon, 02 Aug 2010 10:59:19 GMT

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

What is Show Value attribute in Expression Definition?

Mon, 02 Aug 2010 11:23:58 GMT

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

What is Show Value attribute in Expression Definition?

jonathandienst — Mon, 02 Aug 2010 11:43:10 GMT

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

What is Show Value attribute in Expression Definition?

kji — Mon, 02 Aug 2010 11:54:20 GMT

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.

What is Show Value attribute in Expression Definition?

shumailh — Tue, 03 Aug 2010 07:59:25 GMT

Johan,

Can you share some example on this. I m still not getting any idea about this option.

Shumail

What is Show Value attribute in Expression Definition?

kji — Tue, 03 Aug 2010 08:39:34 GMT

if you put an expression like Dim='A', this will make a value on datapoint to appear only on the Bar or Symbol associated with the value A for Dim.

What is Show Value attribute in Expression Definition?

shumailh — Wed, 04 Aug 2010 11:30:33 GMT

Johan,

I would appreciate if you can share some example on this, I am still not able to implement it.. and i dont understand which point i am missing.

In ur last post this DIM is a field name / variable, I tried similar like this in Show Value attribute but not helping no change. Can u share us what u did and what result u are getting.

Shumail

What is Show Value attribute in Expression Definition?

Miguel_Angel_Baeyens — Wed, 04 Aug 2010 12:01:02 GMT

Hello Shumail,

Take any line chart you have, and set Dimension > 100 in the "Show Value Attribute" dialog where "Dimension" is an actual dimension in your chart, and 100 is an actual value possible for that dimension. Instead of showing values in all points, value it will only shown in for that dimension.

Regards.

What is Show Value attribute in Expression Definition?

shumailh — Wed, 04 Aug 2010 13:58:11 GMT

I tried this in the attached file but no result, can u please look into it where I am lacking?

Shumail

What is Show Value attribute in Expression Definition?

Miguel_Angel_Baeyens — Wed, 04 Aug 2010 14:03:40 GMT

Hello Shumail,

Just check your expression, you are using 1.500.000 in condition and should be 150.000, as there are no such high values for Sum(Amount)

Regards.

What is Show Value attribute in Expression Definition?

jonathandienst — Wed, 04 Aug 2010 14:20:10 GMT

Shumail

You need to turn off the Show data option on the Presentation tab.

Is this (attached) what you need?

Jonathan

What is Show Value attribute in Expression Definition?

shumailh — Wed, 04 Aug 2010 14:40:34 GMT

Thanks Miguel

What is Show Value attribute in Expression Definition?

shumailh — Wed, 04 Aug 2010 14:41:17 GMT

O man u r great, lolz i was missing this point. Thanks

Shumail

What is Show Value attribute in Expression Definition?

Tue, 10 Aug 2010 08:53:03 GMT

Hi Shumail,

I tried for what you thanked Miguel. I am still not getting it.

Can you share QV file having show value attribute used?

I will be greatful.

Thanks,

Happy Thoughts