topic Re: Bar chart calculation in QlikView

Bar chart calculation

nakuldev — Tue, 08 May 2018 11:03:17 GMT

Hi,

In the attached file I have a bar chart where it is populating proper data when any of the country filter is selected. But the main issue is when we clear the country filter the values were completely different its because of CPI conversion. Please help me with this issue.

Thanks in Advance

Nakul

Re: Bar chart calculation

sunny_talwar — Tue, 08 May 2018 15:34:00 GMT

What is the expected values when not Country is selected?

Re: Bar chart calculation

nakuldev — Wed, 09 May 2018 07:34:17 GMT

Hi Sunny,

We gave expression as Avg and values are perfect when we select any country but without any selection it should take avg for all the countries where the avg is going wrong. Could you please check once

Thanks

Nakul

Re: Bar chart calculation

sunny_talwar — Wed, 09 May 2018 09:01:52 GMT

For example if Labor Type normalized is 10 for country a and 20 for country b, you would like to see 15 when nothing is selected? because (10+20)/2 = 15?