Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
nakuldev
Creator
Creator

Bar chart calculation

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

3 Replies
sunny_talwar

What is the expected values when not Country is selected?

nakuldev
Creator
Creator
Author

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

sunny_talwar

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?