Join Problem On Pivot Table

[berkarmagan]

Hi,

I need to learn how qlikview joins table. I searched some and I think if i dont write anything about join on script, it joins table like inner join. In my Project i ve got a table in script which has customer codes and their values. At the sam time i ve customer table like below.

If i dont right any join staffs on script it join them with inner join i guess and i losing customers which are not in main table.

I need to calculate according to example below, sum of values which is 5+5+2+5+7 and divide it with count of customers which is 7. IF dont use joins in script qlikview giving me19/5 but i need 19/7. I tried outer join on script but it didnt work. Thanks for ur help for now.

customer code	value				customercode
1	5				1
2	5				2
4	2				3
5	5				4
6	7				5
					6
					7

[hic]

No, you should not join in the script. Just load the two tables:

     Load [customer code], value From Table1 ... ;

     Load [customer code], <other customer fields> From Table2 ... ;

Then you can calculate what you want (in a chart or a text box) through

     =Sum(value) / Count(distinct [customer code])

HIC