Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
m_perreault
Creator III
Creator III

Fixed Number Limitation Stacked Bar Chart

Hi All,

I seem to be experiencing some strange behavior with the Dimension Limitation and Stacked Bar Chart.

 

I have the below table.  My dimensions are Month Year and Sector and my measures is sum(Fabs(Value))/sum(Total <[Month Year]> Fabs(Value)).  In my table I have a dimensional limit on Sector to show Top 4 and others.

Table.png

 

If I then drag a bar chart over the table I get the following.

 

Bar Chart 1.png

 

However if I choose to stack my dimensions in the bar chart vs group the calculation is erratic and wrong.

Bar Chart 2.png

 

Anyone have any ideas whats happening?


Thanks,
Mark

 

Labels (2)
2 Replies
Lisa_P
Employee
Employee

This does appear strange, I can't replicate it, works fine here.
Lisa_P
Employee
Employee