2 Replies Latest reply: Aug 4, 2017 2:39 AM by Fran Peric RSS

    Barplot with restrictions

    Fran Peric


      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!


      Best regards,