Chart label Issue

[qlikviewwizard]

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]

Like this

[andrei_delta]

Hello,

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

Hope it helps,

Andrei

[qlikviewwizard]

Yes. Please let me know how to achieve this?

[antoniotiman]

See Attachment.

Regards,

Antonio

[qlikviewwizard]

=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]

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.

[tresesco · Accepted solution]

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