issue with bar not showing on chart due to values balancing

[dreweezy]

My current bar chart shows nothing because Qlik Sense thinks that since these 2 values cancels out.

E.g -> I have 2 records in my pivot table

If I convert this to a bar chart (horizontal) I'd expect one bar going to the right 10,000 (movieLocation1) and one bar going left 10,000 (movieLocation2). Qlik thinks these 2 cancel out (which they do) but I'd like to show this visually anyway. Is there a way to override the way Qlik behaves in this situation?

[Channa]

if you bar dimension is MovieLocation it will show 2 bars one Up and one Down or right left

other wise it will cancel

aggregation of those 2 values become 0

[Patrik_Lundblad]

Hi Drew,

If you add MovieLocation as a second dimension to your bar chart and use the stacked bar option then you will see a bar per value. So one going negative and one positive. 

Regards,

Patrik. 

[VishalWaghole]

Posted on your alternative thread.

https://community.qlik.com/t5/New-to-Qlik-Sense/issue-with-bar-not-showing-on-chart-due-to-values-ba...

Thanks,
Vishal Waghole