topic Re: Average Cal in Bar chart is different from Straight Table in QlikView

Average Cal in Bar chart is different from Straight Table

amit_saini — Thu, 12 Jun 2014 04:40:10 GMT

Hi Folks ,

I'm facing on small issue while calculating average in Straight table and in Bar charts. Please see below:

In this Straight table below I'm calculating Act. Tanks Scrapped % as expression = avg(Scrap) which is giving me result 3.4% which is right number. (Here I have set expression total as Average so I'm getting 3,4% which is correct)

Now the same thing I'm calling in a Bar chart calling the same expression =Avg(Scrap) , but here I'm getting average as 3,5% which is not the exact average . As we don't have option for setting Expression Total as Average for Bar chart. I want to show here exactly 3.4% instead of 3.5% .

Kindly help me here in bar chart , how to get exactly average numbers.

Thanks,

Re: Average Cal in Bar chart is different from Straight Table

tresB — Thu, 12 Jun 2014 05:00:28 GMT

Why don't you help us by attaching sample qvw that shows the issue?

Re: Average Cal in Bar chart is different from Straight Table

amit_saini — Thu, 12 Jun 2014 05:24:02 GMT

Tresesco,

Sorry I can't share , but it would be helpful if you can help me how to enable Expression Total (Total Mode) options for Combo chart:

Thanks,
AS

Re: Average Cal in Bar chart is different from Straight Table

tresB — Thu, 12 Jun 2014 05:33:50 GMT

You can't enable that. Workaround - try expression like:

=Sum(Aggr( Sum([Act Scrap $]), Dimension1))