Required Excel Formula in Qlikview

[#1]

Hi All

I want to generate Excel Formula in Qlikview.

I don't want to use DESC in ORDER BY.

I want to use below Formula in Qlikview:

IF(A3=0,"-",IF(A3=A4,"-",B3)) In above Formula A3, A4 and B3 are Excel Cell Numbers.

See the Attached Excel Sheet.

Regards

Eric

[#2]

Thanks Sunny for the Reply.

Is this the Right Approach.

Left Join on the basis of RowNo.

I want to use Previous and Next Row in the same table.

Like this:

If(NAME=NEXTNAME,VALUE1,

IF(NAME=PREVIOUSNAME,VALUE2)) AS New_Code

Is this Possible.

Any idea on this

[sunny_talwar]

This is possible, but I think you need to provide a better sample with whatever you are expecting from us.