Barplot with restrictions

Anonymous — Tue, 25 Jul 2017 13:39:28 GMT

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

Re: Barplot with restrictions

krishnacbe — Tue, 01 Aug 2017 20:07:38 GMT

Can you please share sample data and expecting output

Anonymous — Fri, 04 Aug 2017 06:39:14 GMT

Hey Krishnapriya

I solved my problem.

Thanks anyway!