Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

interndata
New 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
Valued Contributor III

Re: Barplot with restrictions

Can you please share sample data and expecting output

interndata
New Contributor II

Re: Barplot with restrictions

Hey Krishnapriya

I solved my problem.

Thanks anyway!

Community Browser