4 Replies Latest reply: Feb 4, 2017 3:03 PM by Ruben Marin RSS

    Qlik Sense: Line chart with multiple lines

    Niklas Andersson

      Hi,

       

      I'm trying to create a line chart with three lines. Two of the lines are based on a Dimension {Manual registered, Automatic registered} and the third should be the share of the two (ex 75% av Automatic registered), all three lines plotted over time (X-axis).

       

      X-axis I would like to have the date

      Y-axis I would like to have a count of the invoices

       

      My data is in the following format

      InvoiceHeadIDRegisterTypeArrivalDate
      123456Manual2016-01-01
      123457Manual2016-01-01
      123458Automatic2016-01-02
      ...........

       

      I have created a dimension of the field RegisterType and the field ArrivalDatet

       

      My measure is Count(InvoiceHeadID).

       

      However, I cant even get the basic to work, my line chart shows only one line, it does not seem to like my Dimension of RegisterType.

       

      According to the used data the share should be around 75%, and the two lines should therefore be shown, but only one is where it should be, the other once is down by the X-axis and I cant understand why.