Hi,
I have two tables:
table1:
date_1 product quantity
10.02 a 10
11.02 a 5
12.02 a 3
10.02 b 1
11.02 b 2
table 2:
product STORE date_2 price range_from range_to
a S1 11.02 5 1 10
a S1 11.02 6 11 100
a S1 11.02 7 1 01
b S1 10.02 3 1 100
b S1 10.02 5 101
a S2 12.02 5 1 10
a S2 12.02 6 11 100
a S2 12.02 7 1 01
b S2 11.02 3 1 100
b S2 11.02 5 101
In table in QS i want to sum(quantity) but i need condition if date_1 >=date_2 .
Ultimately I would like to have a table:
Table 3:
product store sum(quantity if date_1 >=date_2)
a S1 8
a S2 3
b S1 3
b S2 2
Does anyone know how to write a condition in set expression?
It does not work:
aggr(nodistinct sum( {<store=, product=>} if(data_1>=date_2, quantity,0)),store,product)
