topic Re: 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

sunny_talwar — Tue, 28 Aug 2018 11:03:22 GMT

Where are you looking to do this? in a straight table or another object? What are you dimensions in the object? Can you supply us with a sample to check this out?

Re: help comparing fields in two columns using if statement

jonathandienst — Tue, 28 Aug 2018 11:09:32 GMT

In a straight or pivot table, something like this:

If(Count(TOTAL <id> Quarter) > 1 And Count(TOTAL <id> Distinct Profit) = 1, Max(TOTAL <id> Revenue), Revenue)

Re: help comparing fields in two columns using if statement

Anonymous — Tue, 28 Aug 2018 13:08:51 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!