topic Re: Chart label Issue in QlikView

Chart label Issue

qlikviewwizard — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have monthly data with Sales and Budget.

I am showing Total of Sales and Budget as label in a bar chart.

But whenever Budget value is negative, it is showing the total value twice. But I want to show only once.

Please advise.

Thanks in advance.

antoniotiman — Thu, 05 Oct 2017 08:45:59 GMT

Like this

andrei_delta — Thu, 05 Oct 2017 09:02:33 GMT

Hello,

Try to deselect the Values on Data Points in Expressions Tab for the expression with negative values.

Hope it helps,

Andrei

qlikviewwizard — Thu, 05 Oct 2017 09:09:18 GMT

Yes. Please let me know how to achieve this?

antoniotiman — Thu, 05 Oct 2017 09:13:17 GMT

See Attachment.

Regards,

Antonio

qlikviewwizard — Thu, 05 Oct 2017 09:55:52 GMT

=Dual(Round(sum(Sales+Budget)),Max(TOTAL Aggr(sum(Sales),MonthYear))/5)

Could you please explain Max(TOTAL Aggr(sum(Sales),MonthYear))/5 and why we need to 5?

I confused to apply my original data.

antoniotiman — Thu, 05 Oct 2017 10:10:41 GMT

To set position of the label.

> 5 to the left, < 5 to the right.

If You remove 'Total' then set like 10 instead of 5.

tresB — Thu, 05 Oct 2017 11:08:04 GMT

Or see, if this variant of solution (PFA) works for you.