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

    Barplot with restrictions

    Fran Peric

      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