Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
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).