Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kavita25
Partner - Specialist
Partner - Specialist

Carry forward the dates based on Claim no. and Company code

Hello Everyone,

 

I need to carry forward the "Approve2 Dt " based on company code and claim no.

For e.g if company code is 1 and Claim no is 123 and the date has to be repeated for all the same combination.

Also, attached the sample data.

I have tried the following code:

If(("Claim No." = previous("Claim No.") and "Company Code"=previous("Company Code"))
and len("Approve2 Dt") = 0, Peek('NewValue'), "Approve2 Dt") as NewValue

But coudn't help me to get the expected result.

Please help me to resolve this issue.

 

Regards,

Kavita

 

Labels (1)
2 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

try this:

 

If([Claim No.] = peek([Claim No.], -1) and [Company Code]=peek([Company Code], -1) and len([Approve2 Dt]) = 0, Peek([NewValue], -1), [Approve2 Dt]) as NewValue

kavita25
Partner - Specialist
Partner - Specialist
Author

Hello,

Thank You for the solution. But its not working:

Issue.PNG