topic Showing additional calculations line chart labels in QlikView

Showing additional calculations line chart labels

Thu, 03 Aug 2017 16:06:34 GMT

Hello all,

I am trying to find the approach to build out-of-the-box labels in the line charts and include the results of several formulae.

What I need is to show the values in a way '98% (98 out of 100)', instead of simple percentage '98%'. I have given an example of what I'm trying to achieve below with the red text.

I have found a functionality to add 'Text as a popup' which is helpful, but I'd like the user to see additional information without the need to hover over.

Could anyone share the suggestions how to achieve this?

Thank you!

Re: Showing additional calculations line chart labels

Anil_Babu_Samineni — Thu, 03 Aug 2017 16:27:35 GMT

This may occurs Overlap issue to display that. May be possible

='(' & [% Expression] & ' Out of 100)'

='(' & [% Expression] & ' Out of' & [Full Accumulation Formula] &')'

Re: Showing additional calculations line chart labels

Thu, 03 Aug 2017 22:20:24 GMT

Hello Anil,

Thank you for your reply. This was one of my first ideas to try, but it shows error message in the chart and doesn't show the graph, when I try to do this kind of expression.

Any other ideas?

Thank you!

Re: Showing additional calculations line chart labels

antoniotiman — Fri, 04 Aug 2017 07:56:31 GMT

Hi Tatiana,

try Expression like this

Dual(Num(Sum(Value),'#0 %')&' ('&Sum(Value)*100&' out of 100)',Sum(Value))

Regards,

Antonio

Re: Showing additional calculations line chart labels

Anil_Babu_Samineni — Fri, 04 Aug 2017 08:02:13 GMT

In fact, Dual() can help you. But fortunately the Data points not good to me. As i mention earlier it may over laps. Why not Pop-Up for that using 2 expressions.

Re: Showing additional calculations line chart labels

kusumanchir — Fri, 04 Aug 2017 08:08:45 GMT

Hi Tatiana,

Please find the attached app.

Re: Showing additional calculations line chart labels

Fri, 04 Aug 2017 09:52:36 GMT

Hello Rasly, thank you so much for your help! It works exactly as I needed