Total value not showing up when mouse hover the total bar ...

[#1]

Hi,

May i know is there a way to configure the Qlikview to show the total value when you mouse hover the total bar?

I was using the expression total.

For more info, kindly please refer to the attached word doc and sample QVW file.

Thanks, gk

[#2]

Attached the word doc ... thanks!

[Sokkorn]

Hi gk,

Did you try to check on <Values on Data Points> in Expressions Tab? I think this one is the second solution for your customer.

Regards,

Sokkorn

[#4]

Thanks Sokkorn ... Actually, the customers prefer not to show the values on the chart. Besides this, may i know is there any other possible method? Thanks.

[Sokkorn · Accepted solution]

Hi gt,

Let check my attached file and try to mouse hover the total bar. This one is not a good solution for you yet. But we try to find the best one together.

Regards,

Sokkorn

[#6]

Hi Sokkorn, thanks a lot! Although this may be not a good solution, but it works perfectly fine! Thanks again
Kindly please let me know if you found a better solution...

[Sokkorn]

Hi gk,

I got this solution from John.

So load data like this:

[Data]:
Load * inline [
fiscal_qtr, amount
'2012-Q2', 100
'2012-Q1', 200
'2011-Q4', 300
'2011-Q3', 400
];
[Temp1]:
LOAD
 'Total' AS TypeGroup,
 fiscal_qtr
RESIDENT Data;
CONCATENATE ([Temp1])
LOAD
 fiscal_qtr AS TypeGroup,
 fiscal_qtr
RESIDENT Data;

Create Bar Chart with TypeGroup as Dimensions and Sum(amount) as Expression.

Regards,

Sokkorn

[#8]

Thanks Sokkorn