When the o/p of current expression is NULL use output of above

[qlikviewforum]

In the below pivot table as you see in the row=6,10 and 23 the value of the % Cust Vol is NULL. So what we prefer to have is whenever the output of the expression is NULL we would like show output of the above expression (i,e) for 6th row=81%,10th row=81% and 23rd row=78%.

Formula,
%Cust Vol= ([Cust Buy]+[Cust Sell])/([Buy]+[Sell])

Since the value of [Cust Buy],[Cust Sell],[Buy] and [Sell] is ZERO the output of 6,10 and 23 is NULL.

So can you please help me out to overcome this issue?

[avinashelite]

Did you got the answer ??

[jagan]

Try

Above(Your expression)

Refer QV help file for more details.

Regard,s

Jagan.

[avinashelite]

Try like this

if( len(trim (([Cust Buy]+[Cust Sell])/([Buy]+[Sell]) ))=0 or (([Cust Buy]+[Cust Sell])/([Buy]+[Sell]) )=null() , above(expression_name) , ([Cust Buy]+[Cust Sell])/([Buy]+[Sell]))

[qlikviewforum]

Tried using that but didn't work out.

[jagan]

Try Before().  If possible attach some sample file.

Regards,

Jagan.

[qlikviewforum]

I have tried Before but it is not working. Sorry cannot attach the document for security reasons.

[qlikviewforum]

Above and Before may not work since it is a combination for 4 expressions.

([Cust Buy]+[Cust Sell])/([Buy]+[Sell]))

[jagan]

HI,

Try like this

If(Len(Trim(([Cust Buy]+[Cust Sell])/([Buy]+[Sell])))) = 0, Above(([Cust Buy]+[Cust Sell])/([Buy]+[Sell]))), ([Cust Buy]+[Cust Sell])/([Buy]+[Sell])))

REgards,

Jagan.

[qlikviewforum]

Already tried that but is not working. It is giving the same result as before.

[avinashelite]

As a work around try like this

if( len(trim (([Cust Buy]+[Cust Sell])/([Buy]+[Sell]) ))=0 or (([Cust Buy]+[Cust Sell])/([Buy]+[Sell]) )=null(), 1 , 0)

if the value is setting properly than the issue is with the above statement

I think it because of the segmentation , Above() will not  work win this case .