1 Reply Latest reply: Jun 25, 2016 12:33 PM by Haikuo Yu RSS

    How to use Comparative Analysis to create line chart with Qlik Sense?

    Haikuo Yu

      I would like to create a line chart to compare value of different fruit types at the same month.

      The data is as the following:

      myMonth               myType          myValue

      January 2015          apple               0

      January 2015          banana             1

      January 2015          orange             0

      April   2015            apple                1

      April   2015            banana             0

      April   2015            orange             1

      July    2015            apple               0

      July    2015            banana             1

      July    2015            orange             0

      October 2015          apple              0

      October 2015          banana             1

      October 2015          orange             1

      January 2016          apple               1

      January 2016          banana             1

      January 2016          orange             2

      April   2016            apple               1

      April   2016            banana             0

      April   2016            orange              0

       

      In Tableau, I can use myMonth as Columns, Sum(myValue) as Rows, and myType as Color to create a comparison line chart as the following.

      How could I create the same comparison line chart with Qlik sense?

      Thanks for your help!

       

      compare analysis.JPG