Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

datalakeyu
Valued Contributor

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
datalakeyu
Valued Contributor

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

Get the solution.

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

Thanks!

1 Reply
datalakeyu
Valued Contributor

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

Get the solution.

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

Thanks!