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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compare value from 2 different fields

Hi Everyone, I would like to know how to write an expression which have a condition to compare values of two different fields.

What I am trying to achieve here is to calculate the quantity of a product by having a condition to check the values from two different fields to be same.

For example if field A = 48 and field B = 48 then calculate Quantity if not display 0.

2 Replies
nirav_bhimani
Partner - Specialist
Partner - Specialist

Hi,

Can you please share demo file so that it would be more clear.

Regards,

Nirav Bhimani

Not applicable
Author

Hi Nirav, I have attached a demo. I basically need to calculate the quantity of items in bulk and those in loose. So when the value or data in Bulk_Qty and and Qty_UOM matches this will tell how many items left for each item.