Show graph with data of specific client(s)

[debrouwer]

Dear,

I am quite new to Qlik Sense and would like to ask you for a bit of help.

I would like to have some graphs in my sheet, which only show specific customer(group)s.

For instance; I would like it if my sheet always show a graph with data (delivered units) of customers with name: client_A, client_C and client_K visible in a graph. All (other) customers show in a different graph.

Is this somehow possible and if yes, how?

Thanks in advance.

[VBD]

Hello, you have two method for that,

You can use a set analysis :

For the KPI With specific customers :

sum( {<Customers = {'Customers_A','Customers_B','Customers_C'}>}[Delivery Units])

For the KPI Without these customers :

sum( {<Customers -= {'Customers_A','Customers_B','Customers_C'}>}[Delivery Units])

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysi...

Or you can use alternate state :

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/Visualizations/alternate-...

Regards,

[AsmJuv2004]

Maybe creating a new column based on existing customer column with only client_A, client_C and client_K values and other values as Null. Then you can use the column as dimension in the chart and filter it for excluding null values.