Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a bar chart that shows the sales numbers across years. I also want to show the sales % alongside the sales numbers. How can I do that?
I have tried using a combo chart but then it does let you show the data values which is something I want. Please help.
What is the expression you are using currently? Would you be able to share a screenshot to see the issue?
Following is my expression:
if( Selection='Self', sum(#TotalSelfLed)/sum(UniqueParticipantCount),if( Selection='Rep', sum(#TotalRepLed)/sum(UniqueParticipantCount),if( Selection='Phone', sum(#TotalPhone)/sum(UniqueParticipantCount),if( Selection='Total', sum(#TotalGuidance)/sum(UniqueParticipantCount),
Through this I am displaying the % values but I also want to show the gross numbers on this chart. I tried using the combo chart but it does not let you label the data values which is something we want.
It can be done if you use 2 measures and choose from the number formatting number and percentage to the measure you want to display as percentage.
Thanks for the suggestion. This works for me but now I am not able to color the bars by measure. I do not want single colored bars. Can I do that?
Even better - you can make the percents on a second Y axis so they could be a line vs just a number at the bottom of the bars.
You can do color by measure -
Colors and Legend
and fill in your expression there
or just chose multi-colored if you have more than one set of bars to present