topic Re: we must exclude clients in QlikView

we must exclude clients

Mon, 28 Mar 2016 06:18:31 GMT

good afternoon
such a task

we must exclude clients who bought mango

Client, Product, Date, Sales

1, Apple, 01-01-2015, 750

1, Mango, 01-02-2015, 450

1, Limon, 01-02-2015, 350

2, Apple, 01-01-2015, 1750

2, Limon, 01-02-2015, 550

3, Limon, 01-01-2015, 25

We choose from the list of mango

We see in the table clients 2 and 3

is it possible?

Thanks

Re: we must exclude clients

Chanty4u — Mon, 28 Mar 2016 06:21:20 GMT

try this

sum({<Product=-{'Mango'}>}client)

Excluding values in Set Analysis

Re: we must exclude clients

Kushal_Chawda — Mon, 28 Mar 2016 06:24:22 GMT

try this

sum({<Client=e({1<Product={'Mango'}>})>}Sales)

Re: we must exclude clients

Mon, 28 Mar 2016 06:34:43 GMT

we can choose the list of lemon or apple... or mango and lemon , that is a random selection

Re: we must exclude clients

Kushal_Chawda — Mon, 28 Mar 2016 06:43:39 GMT

Do you mean that based on selection, you want to exclude that product?

Re: we must exclude clients

Mon, 28 Mar 2016 06:47:57 GMT

Yes exactly

Re: we must exclude clients

Kushal_Chawda — Mon, 28 Mar 2016 07:01:42 GMT

create the variable as vExclude on front end with below expression

=concat(chr(39)&Product&chr(39),',')

Now use the set analysis as below

sum({<Client=e({1<Product={$(vExclude)}>})>}Sales)

This will show the error but it will work..

Re: we must exclude clients

Mon, 28 Mar 2016 07:11:10 GMT

Many thanks

Re: we must exclude clients

Kushal_Chawda — Mon, 28 Mar 2016 07:20:14 GMT

Welcome

Re: we must exclude clients

uacg0009 — Mon, 28 Mar 2016 08:37:14 GMT

Hi Kush,

I'm also interested in this question, and I saw your answer, but I tried it, it didn't work, I just don't know how to use it to make it work, could you please help me to check my attachedment?

Thanks a lot!

Aiolos Zhao

Re: we must exclude clients

Kushal_Chawda — Mon, 28 Mar 2016 10:24:26 GMT

Currently I am not able to open the application as I don't have Qv installed in the system

Re: we must exclude clients

veidlburkhard — Mon, 28 Mar 2016 11:04:18 GMT

Hi Aiolos,

see the picture below. You have to tell the e function on which dimension it should exclude...

Happy qliking

Burkhard

Re: we must exclude clients

uacg0009 — Tue, 29 Mar 2016 01:31:22 GMT

Hi Veidl,

Got it! Thank you so much!

Aiolso Zhao