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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bar chart - to show unique count (restrict repeating values)

Hi,

I need to create a bar chart with the below requirement.

Let's assume the below mentioned sample data,

CustomerField Name
AAD
ABG
ABM
BAD
BBK
BBM
CKL
CBG
CSR
CBM

If customer A is selected, it needs to show the unique field count used by other customers in a bar chart. For customer A, there are 2 same fields in customer B and C.

But the "Field Name" = BM is getting repeated in customer B and C, so the count needs to be 2 for customer B and 1 for customer C in bar chart.

I just need to show only the unique fields count in the chart. All help appreciated.

Attached sample data and qvw file.

Regards,

Siva

2 Replies
vishsaggi
Champion III
Champion III

Why customer C needs to be 1? Your C customer has a field name BG that matches customer A. Right?

Anonymous
Not applicable
Author

Yes, the customer C has two field names matching with customer A - BG and BM. But the field BM is already matching with customer B too.

When the field is repeated again, I need to ignore them in the count. So, the result should be Customer B - 2 fields (AD and BM) & Customer C - 1 field (BG).

The unique fields matching with customer A from other customers are totally 3 fields (AD, BM and BG).