Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ankit28287
New Contributor III

removal of negative accumulation

Hi guys ,

               i created one line chart in that accumulation is there. i want to show only positive accumulation , is there any way by which i can remove negative line or transparent that. as due to that other information is hiding. Please refer attach files.

4 Replies
cabhijit
Valued Contributor

Re: removal of negative accumulation

use RangeMax function to neglect negative values.

eg. RangeMax(Sum(Sales),0)

ankit28287
New Contributor III

Re: removal of negative accumulation

yes it help but not solving issue fully

i want - where accumulated value is negative than there 0 should come or no line for that

while by range max, previous value is coming or no accumulation happen for that.

Business wants - only gaps (where actual sales < budget\target sales)

no lines when actual > target as there is no gap..

can you help

cabhijit
Valued Contributor

Re: removal of negative accumulation

RangeMax(Sum(Sales),0)

Above syntax will return zero when sum(Sales) is negative and thus negative value will not interfare with the calculation of chart.

ankit28287
New Contributor III

Re: Re: removal of negative accumulation

please check attachment

in that for FY15 - gap is coming (8,13,13,13) when using RangeMax

while i want answer as (8,13,2,0) as gap(Target - Actual)

Community Browser