topic Re: How to use Set analysis in Pie Chart? in QlikView

How to use Set analysis in Pie Chart?

Anonymous — Wed, 13 May 2015 06:02:04 GMT

Hello,

I have created a pie chart using nationality as dimension and the below expression:

Count(DISTINCT [Member Card Number]).

Now I want to have another pie chart similar to this one but it should not change as I change filters.

Please tell me how to implement that.

Thanks in advance.

crusader_ — Wed, 13 May 2015 06:06:46 GMT

Hi,

Try this one

Count({1} DISTINCT [Member Card Number])

Hope this helps.

Regards,

Andrei

mohammadkhatimi — Wed, 13 May 2015 06:12:45 GMT

Hie..

=Count( {1} DISTINCT [Member Card Number])

Examples:

sum({1} Sales)

Returns total sales within the application, disregarding selections but not

the dimension.

Hope this will helps you

Regards,

Mohammad

Anonymous — Wed, 13 May 2015 06:56:29 GMT

This did not work; but thanks for informing.

But then somethin else worked. I created two pie charts, and detached one of them 🙂

mohammadkhatimi — Wed, 13 May 2015 07:22:24 GMT

Hie...

I just want to know, why did u create two pie charts.??

My expression didnt worked ????