Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

micheledenardi
Valued Contributor

Double value visualization on combo graph

Hi,

i have a problem with the combo graph that show me double value in the top og the column.

i attach a .JPG that explain the problem.

Tags (1)
1 Solution

Accepted Solutions
kuba_michalik
Contributor III

Re: Double value visualization on combo graph

Oh, I see now.

If you actually need "Show Value" conditional presentation, then I guess the only way is to split the expression. Copy and paste it, leave only "bar" for one copy and "line" for the other, then disable "Values on data points" for both, and leave the "Show Value" expression only for one of them.

Take note, "Show Value" does not show whatever the formula under it evaluates to, beyond true/false (0 or null is false, everything else is true). It's just a switch to decide if the value should be shown for a particular datapoint or not. It's easy to see if you just input any number other than 0 there, and see if it changes anything...

But if you need to show those values always, then "Show Value" is unnecessary, keep the single expression and use "Values on data points" instead.

8 Replies
kuba_michalik
Contributor III

Re: Double value visualization on combo graph

I'd hazard a guess one value is for the bar and other for the line. Uncheck "Values on datapoints" for one of the expressions on the Expression tab, just see which one will look better.

Re: Double value visualization on combo graph

You have "Value on data point" selected for both the expressions ...

micheledenardi
Valued Contributor

Re: Double value visualization on combo graph

i have only one expression and "Values on datapoints" in unchecked....

micheledenardi
Valued Contributor

Re: Double value visualization on combo graph

if i disable "show value" on the expression and check "Value on data point" the graph snow value only one time.

But when i use "show value" (with a formula inside), the value appears two times.

Re: Double value visualization on combo graph

Could you please share your object?

micheledenardi
Valued Contributor

Re: Double value visualization on combo graph

you are right Jakub, one value is for the bar and one for the line

kuba_michalik
Contributor III

Re: Double value visualization on combo graph

Oh, I see now.

If you actually need "Show Value" conditional presentation, then I guess the only way is to split the expression. Copy and paste it, leave only "bar" for one copy and "line" for the other, then disable "Values on data points" for both, and leave the "Show Value" expression only for one of them.

Take note, "Show Value" does not show whatever the formula under it evaluates to, beyond true/false (0 or null is false, everything else is true). It's just a switch to decide if the value should be shown for a particular datapoint or not. It's easy to see if you just input any number other than 0 there, and see if it changes anything...

But if you need to show those values always, then "Show Value" is unnecessary, keep the single expression and use "Values on data points" instead.

micheledenardi
Valued Contributor

Re: Double value visualization on combo graph

Thank's Jakub ! you are right !!!!