issue with bar not showing on chart due to values balancing
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?