Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
interndata
Contributor II
Contributor II

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

interndata
Contributor II
Contributor II
Author

Hey Krishnapriya

I solved my problem.

Thanks anyway!