Expression based on non associated fields

Mon, 28 Feb 2011 06:58:50 GMT

I think that this might be simple, but I couldnt solve it.
I have 2 tables: Orders and Budget.

Orders:
OrderDate, OrderMonth, OrderDay, ValueO
2010-12-30, 12, 30, 1500
2010-12-31, 12, 31, 2000
.....

Budget:
BudgetDate, BugetMonth, BugetDay, ValueB
2010-12-30, 12, 30, 1500
2010-12-31, 12, 31, 2000
2010-12-31, 12, 31, 1000

....

Besides those 2, I have a lot more tables, in a way I cannot associate those 2. So the 2 tables are not associated, and I cannot use BudgetDate as OrderDate.

And the result I am expecting is a table like that:
Result:
Day, Month, Orders, Budget
30, 12, 1500, 1500
31, 12, 2000, 3000

Day And Month are dimensions from Orders table. The fields Orders and Budget must be expressions. I was thiking something like that:
Order = Sum(ValueO)
Budget= Sum ( {$<BugetMonth=( 'Month Dimension Value' ) and BugetDay=( 'Day Dimension Value' )> ValueB}

Expression based on non associated fields

lironbaram — Mon, 28 Feb 2011 07:11:41 GMT

hei

try this one

hope it helps you

Expression based on non associated fields

Mon, 28 Feb 2011 13:37:35 GMT

In that way, it worked.

But I have a lot of fields, that I can filter or not: customer, product, year and month. These filters need to be on both tables, and they are not associated.

topic Expression based on non associated fields in QlikView

Expression based on non associated fields

Expression based on non associated fields

Expression based on non associated fields