Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!