Compare two columns from different tables in a condition in Qlik View

[#1]

Hi,

I need to get current day's data where Table1.Column1_value > Table2.Column_2_Value.

Table2.Column_2_Value is a threshold value corresponding to column1 in Table1.

I tried with set analysis

Below mentioned set analysis gives the data for Today's date

Sum({<DATE= {"$(=Date(today(),'YYYY-MM-DD'))"}>}Sales)

But I can't add a field to field comparison inside  the above mentioned set analysis

I need a formula that gives the same data as the following query

Select Sum(Sales) from Table1 join Table 2 on (...)

Where Date=Today() and Table1.Column1_value> Table2.Column_2_Value

Thanks

[swuehl · Accepted solution]

And you need this in a chart?

Note that this might not perform very well on large data sets:

=Sum( If(Date = Today() and Table1.Column1_value > Table2.Column_2_Value, Sales))

You are only able to replace this with a set expression if you find a key that returns for each combination of your tableX columnY values a unique answer.

[#3]

Thanks Swuehl. Great help