Join Problem On Pivot Table

berkarmagan — Fri, 05 Jun 2015 13:53:51 GMT

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

Re: Join Problem On Pivot Table

hic — Fri, 05 Jun 2015 16:24:08 GMT

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

topic Join Problem On Pivot Table in QlikView

Join Problem On Pivot Table

Re: Join Problem On Pivot Table