Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
tomovangel
Partner - Specialist
Partner - Specialist

Comparison of 2 expression with the same value

Hello, Guys


I am working on a rather interesting solution, on which i would like to see some input from the Pros

 

notsame.jpg

 

In the load script i have used the following expression, because I thought that I have some symbols after the coma

Round(sum, 0.001) as delay_sum
Round(sum, 0.001) as paid_sum_res

 

 

On some of the ID's that I am going through the formula evaluates correctly, but for 3% of the dataset it doesn't evaluate if column1=column2 correctly, like in the case of the screenshot. 

How Can i format the numbers, or the expressions to get the true value when I compare these columns?

2 Replies
dwforest
Specialist II
Specialist II

hard to tell why with what you've shown, need the rest of the sample data. don't understand the need for delay_sum and paid_sum_res with the same formula either.
column1 = column2 does not have a obvious relation to type_res.
Set Expression would also work in lieu of if
Sum({$<type_res={'delay_interest'}>} paid_sum_res
tomovangel
Partner - Specialist
Partner - Specialist
Author

paid sum res is the payment amount, but with different types(type_res). 

 

Delay_sum is the delay_interest assigned to each UNIQUE ID. 

 

I want to get the following logic 

sum(If(sum(delay_sum)<=Sum({$<type_res={'delay_interest'}>} paid_sum_res,delay_sum))

Basically i want to check if the payment for this specific type is done, and if it is take the delay_sum.