topic Re: Issue in combo chart while shoiwng negative values using Axes in QlikView

Issue in combo chart while shoiwng negative values using Axes

Fri, 22 Apr 2016 10:12:00 GMT

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.

Re: Issue in combo chart while shoiwng negative values using Axes

Gysbert_Wassenaar — Fri, 22 Apr 2016 15:34:38 GMT

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:

Re: Issue in combo chart while shoiwng negative values using Axes

HirisH_V7 — Sat, 23 Apr 2016 08:07:39 GMT

Hi,

May be like this,

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

By taking the values which are than less than zero,

Hope this helps,

PFA,

Hirish