Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Additional calculations for bar chart label

I have a bar chart showing the COUNT(Opportunity_ID) for each Product_Type. I'd like for the user to be able to hover over each bar and in the pop-up text show SUM(Value).

Is this possible? If so, can someone please advise me?

THANK YOU!

Tags (3)
3 Replies
elena888
Valued Contributor

Re: Additional calculations for bar chart label

Yes, you can edit two expressions and set different options:

First expression: COUNT(Opportunity_ID) ->in presentation tab uncheck labels pop up

Second expression: SUM(Value) -> in expression tab uncheck bar and check text as pop up


KR

Elena

Not applicable

Re: Additional calculations for bar chart label

Elena,

Thank you. That worked, but as a follow up -- I have group two expressions together to allow for a cyclic toggle. Can I have the bar chart for Toggle1 show SUM(Value1) and Toggle2 show SUM(Value2)?

Thanks in advance..

elena888
Valued Contributor

Re: Additional calculations for bar chart label

I don't know if I have understood...

If you want to show values of the two expression grouped - sum(Value1) and sum(Value2) - just in the pop up, you can uncheck "bar"  and check "Text as pop up" for both and then group them.

Please, if it's not correct my interpetation of your question, put on an example qvw