topic help comparing fields in two columns using if statement in QlikView

help comparing fields in two columns using if statement

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

hey everyone, I am relatively new to the community. I have a question. I have a table shown below

I need a statement that will select the higher revenue if profit in Q1 and Q2 of id 1 are the same.

Thanks!

Re: help comparing fields in two columns using if statement

ogautier62 — Tue, 28 Aug 2018 06:37:55 GMT

Hi,

use a sheet with dimension : id,quarter,profit

and max(revenue) as measure

regards

Re: help comparing fields in two columns using if statement

jyothish8807 — Tue, 28 Aug 2018 07:11:26 GMT

Hi Titus,

Try this:

max(total <id,Proft>Revenue)

Br,

Re: help comparing fields in two columns using if statement

raman_rastogi — Tue, 28 Aug 2018 07:21:28 GMT

Hi,

May be like this

Aggr( max( Revenue),id,Profit)

Re: help comparing fields in two columns using if statement

Anonymous — Tue, 28 Aug 2018 13:10:43 GMT

thanks guys for the response, so this is the main table. Please dont mind the erased part, they are same number

as you can see different plants have different storage locations. I need another field that will serve as a flag to indicate the higher current stock if the storage locations are same but different plants.

I hope that makes sense. Please your response will be greatly appreciated.

Thanks!