topic Re: Chart settings, adding value on data points in QlikView

Chart settings, adding value on data points

Wed, 13 Nov 2013 19:50:33 GMT

I have a 2 dimension bar chart with 2 expressions.

The expression values are stacked since it has 2 dimension.

I want to display a custom text inside the bars, but only for one of the bars.

When i enable plot data values inside segment, it adds it to both bars, is there a way to make it show only on one of the bar values ?

sample:

I want the text to show only on the red bars.

Re: Chart settings, adding value on data points

jerem1234 — Wed, 13 Nov 2013 20:01:59 GMT

try Instead of your expression "20", change it to dual(Text,20) and check Values on Data Points. Then you can get rid of your expression "Text".

Hope this helps!

Re: Chart settings, adding value on data points

Wed, 13 Nov 2013 20:54:31 GMT

dual(Text,20)changed everything 'AA' text.

Not exactly understanding the usage of Dual() yet

Re: Chart settings, adding value on data points

Clever_Anjos — Wed, 13 Nov 2013 21:05:41 GMT

PFA

Re: Chart settings, adding value on data points

Wed, 13 Nov 2013 21:11:59 GMT

I might have not clarify my question properly but

I want to have custom text based on the rw data showing.

showing values works fine with the expression having values on data point enable but i require text, thats where the custom expression comes in, with bar disable. The problem is it, is showing in the other bar also, when i enable Plot values inside segment.

Re: Re: Chart settings, adding value on data points

Anonymous — Wed, 13 Nov 2013 22:04:49 GMT

Jun

I hope I have understood what you are after, have a look at the attached and advise what you think.

Best Regards, Bill

Re: Re: Chart settings, adding value on data points

Clever_Anjos — Wed, 13 Nov 2013 22:06:16 GMT

It´s not exactly what you want, but maybe fits your needs

PFA

Re: Chart settings, adding value on data points

Wed, 13 Nov 2013 22:13:01 GMT

Hi Bill,

As mention in the first post, its a custom text i'm trying to display and not use the original value used to create the bar.

This is more of a formatting hack rather than using default chart settings.

Re: Chart settings, adding value on data points

Wed, 13 Nov 2013 22:16:04 GMT

Thanks, but i have already tried this.

But sadly, its requirements and i cant try alternative to the requested format.

Data wise, its showing all the number/text,

but they want it for the aesthetics.

Re: Chart settings, adding value on data points

Anonymous — Wed, 13 Nov 2013 22:18:52 GMT

Jun

I am not sure I understand what you mean by 'custom text' could you describe what text values you after and if appropriate the algorithm to create them ?

Best Regards, Bill

Re: Chart settings, adding value on data points

Clever_Anjos — Wed, 13 Nov 2013 22:21:31 GMT

Is this what you want?

Re: Chart settings, adding value on data points

Wed, 13 Nov 2013 22:26:59 GMT

Please see the first post,

i have attached an image and the sample .qwv of what I'm trying to work with.

Notice the 2 set of bars.

Set A

Set B

Each Set have items 2, 15, 21

Each Item is a bar, produced by 2 expressions

exp [20] --- 20 because this is a static value

exp [value] --- value pulled from data table

By default, if [Values on data point] is enabled, the exp value is displayed on top of the bar.

When [Plot values inside segment] enabled, each exp will have its value displayed in the middle of its respective bar.

By adding a 3rd exp, and disabling the [bar] option, and enable [Values on data point],

i can show any custom value i want within the bars.

The problem i have here is, it is showing up twice.

I want it to show on the top bar only.

Re: Chart settings, adding value on data points

Wed, 13 Nov 2013 22:27:36 GMT

yes, this exactly what i'm trying to produce

Re: Re: Chart settings, adding value on data points

Clever_Anjos — Wed, 13 Nov 2013 22:28:52 GMT

A small trick

Two bars with same colors, one with height of 6, another yourvalue-6

Re: Chart settings, adding value on data points

Wed, 13 Nov 2013 22:35:21 GMT

Am i missing something,

the =Dual(text, value) function is returning all 'AA' text

Re: Chart settings, adding value on data points

Clever_Anjos — Wed, 13 Nov 2013 22:38:50 GMT

Could you post a print of my app, I want to see what you´re seeing

Those are my expressions

Re: Chart settings, adding value on data points

Anonymous — Wed, 13 Nov 2013 22:44:24 GMT

Anjos

I downloaded your qvw and it looks good to me as in it is, BB, CC, AA B B, CC, AA when I look at it.

Re: Chart settings, adding value on data points

Wed, 13 Nov 2013 22:44:36 GMT

It should be the same right ?

I downloaded your .qvw and open it as it.

But instead of the text in BB, CC, AA sequence, its all AA

not sure what is different exactly.

Re: Chart settings, adding value on data points

Clever_Anjos — Wed, 13 Nov 2013 22:47:21 GMT

Yes, should be exactly the same

Bumped...

Which QV version are you using?

Re: Chart settings, adding value on data points

Wed, 13 Nov 2013 22:53:55 GMT

v 11.20.11718.0 SR1