Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

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

Capture.PNG

 

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?

 

 

3 Replies
Channa
Valued Contributor III

Re: issue with bar not showing on chart due to values balancing

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

Channa
Highlighted
Employee
Employee

Re: issue with bar not showing on chart due to values balancing

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
Valued Contributor II

Re: issue with bar not showing on chart due to values balancing