Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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



1 Solution

Accepted Solutions
Kushal_Chawda

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
Chanty4u
MVP
MVP

try this

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

Excluding values in Set Analysis

Kushal_Chawda

try this

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

Not applicable
Author

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





Kushal_Chawda

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

Not applicable
Author

Yes exactly

Kushal_Chawda

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

Not applicable
Author

Many thanks

Kushal_Chawda

Welcome

uacg0009
Partner - Specialist
Partner - Specialist

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