topic Re: Comparing 2 Numeric Fields in an Expression in QlikView

Comparing 2 Numeric Fields in an Expression

Thu, 17 Jul 2014 08:53:10 GMT

Hi,

we have one table in data model with columns M2 and M5 (both numeric).

We have a formula (with set analysis conditions) that filters the data set in the table. Formula goes something like this:

=sum({$<M2={">0"}, M2={">0"}>} flagOO)

We have veryfied that we get the correct subset from the table.

In the following step we would like to make a following comparison:

M5={">=M2"}>

and sum the resulting rows (flagOO can only have numerical value of 1)

Our approach is (and it is not functioning as we expect):

=sum({$<M2={">0"}, M2={">0"}, M5={">=M2"}>} flagOO)

Can you please give us a suggestion on how we should adapt the formula? Thx!

hic — Thu, 17 Jul 2014 08:56:03 GMT

The M5>=M2 is a comparison that must be made on the row level (not globally), so you cannot use Set Analysis for that. Instead, do a

=sum({$<M2={">0"}, M5={">0"}>} If( M5>=M2, flagOfferOrder))

HIC

Thu, 17 Jul 2014 09:38:41 GMT

Thnks Henric!
This is the correct answer!

Best regards,