topic Re: Additional calculations for bar chart label in QlikView

Additional calculations for bar chart label

Mon, 22 Dec 2014 19:09:09 GMT

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!

Re: Additional calculations for bar chart label

Anonymous — Mon, 22 Dec 2014 20:00:07 GMT

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

Elena

Re: Additional calculations for bar chart label

Mon, 22 Dec 2014 20:02:33 GMT

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..

Re: Additional calculations for bar chart label

Anonymous — Mon, 22 Dec 2014 20:12:18 GMT

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