Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaushik2020
Creator III
Creator III

Is it possible to show custom calculation on the bar labels ?

I am looking for a solution where I want to show Custom calculations as Bar labels. Current ones show the default measure. 

I wanted to know if we can show a custom calculation on barchart as a lable. 

ex:

Default measure - Sum(Sales)

Bar labels - Variance between Sum(Sales) and Sum(Budget)

Note: this I am looking for the labels, not the tooltip on hover.

 

Thanks in advance. 🙂 

Labels (5)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Use a Dual() Expression

=Dual(      Num(Sum(Sales) - Sum(Budget),'$#,###') ,   Sum(Sales) )

Choose Number Format = Measure Expression

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

2 Replies
vinieme12
Champion III
Champion III

Use a Dual() Expression

=Dual(      Num(Sum(Sales) - Sum(Budget),'$#,###') ,   Sum(Sales) )

Choose Number Format = Measure Expression

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Kaushik2020
Creator III
Creator III
Author

Thanks a lot for your swift revert