topic Value on Data Point Stacked Bar - Only on Top in QlikView

Value on Data Point Stacked Bar - Only on Top

demcug82 — Fri, 22 Jul 2016 10:59:15 GMT

Hi,

i have a Stacked Bar and i would like to show only one value on data point on the top.

I created two expression:

1) for bar chart

2) for label

I have a negative value for a segment (-298) , so Qlik insert me two label (on top and on down)

How can I do to show label only on the sum (In this case only on the top) ?

Re: Value on Data Point Stacked Bar - Only on Top

sunny_talwar — Fri, 22 Jul 2016 11:34:52 GMT

May be create another label which just display the Sum by the your first dimension using Aggregate and place it on the chart. I will have to play around with it to give a better response, but try playing around with it your end as well.

Best,

Sunny

Re: Value on Data Point Stacked Bar - Only on Top

sunny_talwar — Fri, 22 Jul 2016 11:49:19 GMT

See if the attached application helps:

Re: Value on Data Point Stacked Bar - Only on Top

demcug82 — Mon, 25 Jul 2016 09:27:49 GMT

Hi Sunny,

ty for help but i have to use total.

My expression it's: (your sum(value))

num(round(sum(total <F.COMPETITOR, F.Y_Quarter>F.#ACT_E)),'#,##0') (Operating Income = F#ACT_E)

and only for business segment > 0 i would to like sum total

so i tried:

dual(if(num(round(sum(total <F.COMPETITOR, F.Y_Quarter, F.BUSINESS_SEGMENT>F.#ACT_E)),'#,##0') >=0, num(round(sum(total <F.COMPETITOR, F.Y_Quarter>F.#ACT_E)),'#,##0'),''),num(round(sum(total <F.COMPETITOR, F.Y_Quarter>F.#ACT_E)),'#,##0'))

If i use > 0 in "IF..." not works (2 record > 0 and 2 <= 0 ) see image . Not insert label

IF i use >= 0 in "IF..." WORKS (3 records VS 1 that are in >= 0 Insert one label on the top

This it's strange ....too

Why??