can anyone help me out??

[suvechha_b]

select period_key,product_key,sum(actual_receipts_qty)

from jnbvdw02a.edw.dbo.fact_mps

group by period_key,product_key

having product_key='73219' and period_key>=135

how to projected this "group by" in qlikview model???

[tresesco]

try replacing 'having' with 'where'

[#3]

In qlikview also you can use group by, for having use where

[#4]

Data_Temp:

Load *

from sorce table....Where product_key='73219' and period_key>='135';

Data:

Load *

Then groupBY

resident Data_Temp;

Drop table Data_Temp;