Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
jonathan_ineox
New Contributor III

How to do "where" in qliksense

Hello everyone
I have a question :I have two tables in qliksense
1- customer list (customer num)
2- sales tickets (customer num)
I would like to count the number of customers in my list of customer who have made purchases (sales tickets). I do not know how to do a "where num Client [client list] = num Client [list tickets] in qliksense.
Can someone help me?


Regards,

2 Replies

Re: How to do "where" in qliksense

Hi,

Use the exists function like below.

Load Customer,Sales from SalesTicket;

Load Customer,If(Exists(Customer),'Yes','No') as CustomerWhohasSales

From Customer.

Now you can use this new field "CustomerWhohasSales" to know which customer had sales and using this you can also count the customers.


Regards,

Kaushiik Solanki

jonathan_ineox
New Contributor III

Re: How to do "where" in qliksense

Hello Kaushik,

Thank you! It's a good idea.
I'm going to try it

Community Browser