Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
abhinavbose
Creator III
Creator III

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?

abhinavbose
Creator III
Creator III
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).