Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jaswantc
Creator II
Creator II

Help on Assigining InputFiled value to forward records

Hi All,

I assigning new Price thorugh InputField and this value has to assigned for forward Period Unless Untill new value assigned then take that new price to take it forward.

Like Below assigned 800$ start of 201910 and it is valid up to 202003 See in NewWAC Column and in 202003 entered new price 780 and it should be 780$ starting from 202003 instead of acumulated price from previous value.

Can some body advice me on this aggregation.

expression:

If(WacPrice,WacPrice,

                 sum(aggr(rangesum(above(TOTAL inputsum(WacPrice),0,RowNo())),NDC11,Period))

)

2 Replies
jaswantc
Creator II
Creator II
Author

Hi Can any one help on this logic?

jaswantc
Creator II
Creator II
Author

re posting , appreciate any one advices on this