topic Set analysis in Straight Table in QlikView

Set analysis in Straight Table

Wed, 11 Jun 2014 14:13:00 GMT

Hi,

I've got an issue unsolved

I've got three Types of shops:1,2,3

and 9 Shops that each of them belong to a type

for each shop I've got the sales

now I want in the chart itself to show the difference between certain shop to the shops of the same type

For example:

Shop A belongs to Type 1 and has 100 sales,

The Avg. of type 1 is 150, therfore the answer in shop A Line will be 150

I attached the file

thanks in advance for the helpers.

Jacob

Nicole-Smith — Wed, 11 Jun 2014 14:17:43 GMT

Your expression should be:

avg(total <Type> Sales)

Correct file is also attached.

alexandros17 — Wed, 11 Jun 2014 14:24:14 GMT

Here it is your document

let me know