Displaying customer list with specific information

[nbaadjacent]

Hi everyone,

I'm working with QlikSense and need some help with a specific task. I have two lists of names:

1. A list containing all my clients.
2. A list of clients who have purchased certain one specific type of products.

I want to display the complete list of all my clients in QlikSense with an additional column indicating whether each client has also purchased the specific products, as "yes" or "no"

As sources, I have both of my lists seperated in different tables

I've tried with formulas. The closest result was with IF(AGGR(COUNT( but the display is wrong with every clients listed as "yes". I've also tried through the script, but I'm still unsuccessful.

Can someone explain how to do this?

Thanks in advance for your help!

  #developers #script #visuilization #setanalysis

[MatheusC · Accepted solution]

Hi, 

Applymap() mapping the table and creating a “yes” or “no” flag

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFunctio...


- Regards, Matheus

[nbaadjacent]

Thank you very much !