How to calculate expression??

[suvechha_b]

how to do sum of a field depending on period_key and product_key group by....in expression of qlikview??

[Gysbert_Wassenaar]

In a chart you use period_key and product_key as dimensions and sum(field) as expression.

In the script you can do something like:

load

    period_key,

    product_key,

    sum(field) as PeriodProductSum

from ...somewhere...

group by period_key, product_key;

[suvechha_b]

no I dont want period_key and product_key as dimension,

I only want the sum(actual_receipts_qty) against fiscal_year and fiscal_month and product_code.

I have tried your script but it is giving error at load..

I am new, Plz tell me step by step

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling.