Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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


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


Nirav Bhimani

Not applicable

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.