topic Re: Table expression with Set Analysis in QlikView

Table expression with Set Analysis

linoyel — Wed, 28 May 2014 11:51:49 GMT

Hey all,

I need help in writing the table expression.

I have 1 dimension (Products) and my first expression counts people who were interested in that product: count(customers).

I need second expression that will calculate count(customers) for a specific product out of total count(customers) and show the result in percents...

For example, 5 people were interested in apples and 3 people were interested in oranges.

Total is 8 people.

So for the apples row, I need an expression that will do this: 5/8 *100%

And for the oranges row it will be: 3/8 *100%

Of course, all other "current selections" are supposed to stay the same.

Wed, 28 May 2014 11:55:34 GMT

try this:

count(customers) / count({<Products = >}customers)

if you have any other dimensions then Products you also have to use them in set analysis.

regards,

eduardo_sommer — Wed, 28 May 2014 11:56:28 GMT

It's count(customers)/count(TOTAL customers)

Eduardo

Anonymous — Wed, 28 May 2014 11:56:48 GMT

Try out:

(count(customers)/count(total customers))*100

Regards

Nitin

tresB — Wed, 28 May 2014 11:56:53 GMT

I guess the solution was suggested in other thread here holds good. Did you you try that? Otherwise, try to post your sample qvw.

linoyel — Wed, 28 May 2014 11:57:21 GMT

Thank you

This worked

linoyel — Wed, 28 May 2014 11:58:21 GMT

Yes, thank you!

I didn't think it was THAT simple!

Already checked your answer as a correct one in a first thread