Discussion Board for collaboration on QlikView Layout & Visualizations.
I need some help here:
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!
Can you please share sample data and expecting output
I solved my problem.