topic Set Analysis in QlikView

Set Analysis

Thu, 16 Apr 2015 19:18:33 GMT

Hello guys,

I have this table:

The column "PROD 5" is dynamic , this aways shows the avg of selected product and then compare with de avg of product and market in the dimension. But I have to show the avg of selected product in the markets of column "MKT".

How can I do it?

I tried to compare in set analysis something like this:

Avg(TOTAL {<PRODUCT={'$(=Only(PRODUCTCOMP))'}, MAKET={$(=Only(MAKET))}>} [SACAS/HÁ])

Avg(TOTAL {<PRODUCT={'$(=Only(PRODUCTCOMP))'}, MAKET={$(=Column(1))}>} [SACAS/HÁ]) (using only(MARKET) of column 1)

but isnt work...

Re: Set Analysis

beck_bakytbek — Thu, 16 Apr 2015 19:55:30 GMT

Hi Cintia,

try to use Resident Load; where you can use: PROD 5 / 5 , where 5 is avg of products in MKT

i hope this can help you

with kind regards

Beck

Re: Set Analysis

Mon, 20 Apr 2015 18:40:15 GMT

it isnt work because the PROD 5 is dynamic selected in a list box. Sorry it was not clear. this is a pivot table, i have a prod. selected in a list box and then compare with others products in the same MKT.

look the qvw file.

Re: Set Analysis

ramoncova06 — Mon, 20 Apr 2015 19:05:52 GMT

Have you tried using the field you want to group by ?

something like Avg(total <Product> Sales)

sorry I am not sure I am getting what you need, can you add an example of the expected output

Re: Set Analysis

Mon, 20 Apr 2015 19:19:20 GMT

omg, its so simple! i almost killing myself...

Thank you so much