Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

we must exclude clients

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



Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: we must exclude clients

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..

View solution in original post

12 Replies
Highlighted
Champion III
Champion III

Re: we must exclude clients

try this

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

Excluding values in Set Analysis

Highlighted

Re: we must exclude clients

try this

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

Not applicable

Re: we must exclude clients

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





Highlighted

Re: we must exclude clients

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

Highlighted
Not applicable

Re: we must exclude clients

Yes exactly

Highlighted

Re: we must exclude clients

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..

View solution in original post

Highlighted
Not applicable

Re: we must exclude clients

Many thanks

Highlighted

Re: we must exclude clients

Welcome

Highlighted
Partner
Partner

Re: we must exclude clients

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