Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense 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