Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
zhenjie911
Not applicable

All item total vs filtered single item total in bar chart

Hi I have a problem where the value shown when highlighted an item and showing all is different in the bar chart.

Once filtered, the value is correct

What's the issue. Ill upload the QVF file together !

Tags (1)
1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: All item total vs filtered single item total in bar chart

Try this

Sum(Aggr(IF(Currency = 'THB', SUM(GRAmount)*vThaiRate, SUM(GRAmount)*1), Sub_category, Currency))

2 Replies
sunny_talwar
Not applicable

Re: All item total vs filtered single item total in bar chart

Try this

Sum(Aggr(IF(Currency = 'THB', SUM(GRAmount)*vThaiRate, SUM(GRAmount)*1), Sub_category, Currency))

zhenjie911
Not applicable

Re: All item total vs filtered single item total in bar chart

this works, and solved