Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shiveshsingh
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
sunny_talwar

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
suryaa30
Creator II
Creator II

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

shiveshsingh
Master
Master
Author

Not working

sunny_talwar

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

shiveshsingh
Master
Master
Author

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