This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I need to create a bar chart with the below requirement.
Let's assume the below mentioned sample data,
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.
Why customer C needs to be 1? Your C customer has a field name BG that matches customer A. Right?
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).