topic Help me to have this report... in QlikView

Help me to have this report...

Sun, 04 Mar 2012 00:12:11 GMT

I got problem in architecture, it has the same amount in each territory.

Sample Output:

Territory	Brand	Sales	Target
A	Brand A	13,000	16,000
	Brand B	6,000	5,000
B	Brand A	14, 000	10, 000
	Brand B	50, 000	55, 000
C	Brand A	10, 000	15,000

I got a problem, in each brand of each territory outputs the same sales. Below is the sample table fields.

Transactions: Targets:

Product Code Territory

Sales Product Code

Target Amount

As you can see in the fields, it doesnt have "territory" field in the Transactions table, that is why it outputs the same sales in each territory. What should I do? Help me please, need it urgent! Thanks.

Best Regards,

Bill

Help me to have this report...

phaneendra_kunc — Sun, 04 Mar 2012 03:05:57 GMT

Are you doing a left join with Targets table?

Do the concatenation and ignore the fileds that doesnt need in set analysis...

Post a sample..if possible...

Regards,

phani

Help me to have this report...

Anonymous — Sun, 04 Mar 2012 19:47:27 GMT

Hi Bill,

Given the nature of the data (no Territory in Transactions table) you cannot tell anything about the Product Sales by Territory. If you had it, the right thing to do would be concatenation of both tables, as Phani said.

Regards,
Michael

Help me to have this report...

Mon, 05 Mar 2012 01:54:33 GMT

Hi Guys,

That's what Im thinking, there is no territory in transaction table so there's no chance of getting sales per territory.

Thanks for the reply.