Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Barplot with restrictions

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

2 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

Can you please share sample data and expecting output

Anonymous
Not applicable
Author

Hey Krishnapriya

I solved my problem.

Thanks anyway!