Question

sebvz1989 — Thu, 22 Apr 2021 21:23:14 GMT

Good morning everyone. I need to perform an operation where I have to make comparisons between fields. The operation is as follows: count the records where my table1 is equal to or less than my table2 and my table3 is equal to or less than my table4. I don't know how to fix this. Please help.

Re: Question

Dalton_Ruer — Fri, 23 Apr 2021 15:36:39 GMT

Your image and explanation aren't enough for anyone to try to help with your specific case. You would need to show example data of each table and example of expected output.

In general - If Table1 and Table2 contain the same basic fields you could simply load them together for the dimensional values, and simply qualify the value fields like "Value_Table1" and "Value_Table2". After you have loaded both tables together like that you can do a simple SELF JOIN and create a flag that compares the values.

JOIN

Load MyKeyField,

IF (Value_Table1 <= Value_Table2, 1, 0) as Table1_LessThanEqualFlag

Resident MyTableName

Then you can create an expression in a KPI that is a simple SUM of that flag:

Sum(Table1_LessThanEqualFlag)

topic Question in App Development

Question

Re: Question