topic Re: Compare value from 2 different fields in QlikView

Compare value from 2 different fields

Fri, 18 Jan 2013 06:46:06 GMT

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.

Re: Compare value from 2 different fields

nirav_bhimani — Fri, 18 Jan 2013 06:50:10 GMT

Hi,

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

Regards,

Nirav Bhimani

Re: Compare value from 2 different fields

Fri, 18 Jan 2013 08:31:51 GMT

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.