Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Get the solution.

We can create a line chart with myMonth and myType as dimension and Sum(myValue) as measure.

Thanks!

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Get the solution.

We can create a line chart with myMonth and myType as dimension and Sum(myValue) as measure.

Thanks!