Load Data with GROUP BY

[#1]

hi i have a question about loading data in qlikview script

i have two fact table called header and line.

i want to summarize quantity in line table by using this script:

load

.........

........

(sum(QTY1)/sum(QTY2)) as VALUE_PERCEN

..........

Resident a

Group by

.........

...........

........

;

All value work fine, but why the value of VALUE_PERCEN return 0 (zero).

Anybody knows why ?

Really need your help.

thanks

[sunny_talwar]

Why don't you join first (so that you don't have to group by Header_ID) and then calculate the percentage, because the current method won't give you meaningful results.

[#3]

Hi Sunny,

Do you mean left join between header and detail table ? so it will be only one table ?

Can you give me the example Sunny ? still dont get the idea

thanks

[sunny_talwar]

Would you be able to share your current script (ideally the complete script)? We here might be able to suggest you something.