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: 
Not applicable

Issue in combo chart while shoiwng negative values using Axes

Hello,

I need one help.

I am having one issue while I am trying to show the bar negative and positive values using Chart Axes property (Scale Static Min and Static Max). I have given functionality to user where user can select the Axes range from slider and it will show the data based on the axes limit set by user. I have created sample file with I put static Min and Static max value in charts . for Only Positive chart it is showing only positive bars but for negative it is showing both. So is there any way we can show only negative bars without make any changes in expression. The reason is I am using dynamic and multiple selection of dimensions.

Thanks in Advance.

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Click on the + in front of the expression, choose Background Color and enter an expression to make the bar transparent if its value is larger or equal to 0:

comm214221.png


talk is cheap, supply exceeds demand
HirisH_V7
Master
Master

Hi,

May be like this,

=If(sum(Value)<0,Sum(Value))

Postive Bar Removing-214221.PNG

By taking the values which are than  less than zero,

Hope this helps,

PFA,

Hirish

HirisH