Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Master
Master

Logic required

Hi guys

please help me in building below logic

I need last column

 

ABCResult
Cat10110
Tiger54210 Divide by 2
Dog563(10 Divide by 2)/3
Rabbit344((10 Divide by 2)/3)/4
Pug Boss435(((10 Divide by 2)/3)/4)/5

Thanks

1 Solution

Accepted Solutions

May be this

=If(RowNo() = 1, B, Above(Result)/C)

or this

=If(RowNo() = 1, B, Above(Column(1))/C)


Capture.PNG

View solution in original post

4 Replies
Creator II
Creator II

=(Result / Alt(above(Result),1))

Master
Master

Not working

May be this

=If(RowNo() = 1, B, Above(Result)/C)

or this

=If(RowNo() = 1, B, Above(Column(1))/C)


Capture.PNG

View solution in original post

Master
Master

Thanks Sunny, got my mistake. small bracket played all the game