Barplot with restrictions

[Anonymous]

Hey

I need some help here:

Example:

I would like to create a bar chart in QlikView according to the column A.

However, column A is related to column B and in B duplicates occur.

Additionally I have a column C, which is a number that represents each user uniquely.

Now some values in B are overlapping although they have different user identifications.

My approach so far:

Bar plot with column A as the x-axis.

count(if('column A'='x','Check')) and count(if('column A'='y','Check'))

Now I would have to implement a code such that QlikView just uses Distinct(column B & '-'  & column C)

Do you have any solutions for this situation?

Thanks in advance!

Best regards,

Vranejs

[krishnacbe]

Can you please share sample data and expecting output

[Anonymous]

Hey Krishnapriya

I solved my problem.

Thanks anyway!