Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ettienero
New Contributor

Line Graph with 2 dimensions and 1 measure over time

Hi

Is it possible to create a line graph showing 2 dimensions over time, as shown in the pic below?Graph1.jpg

In my data I have several shops in an Area. I want to see how a certain shop is performing measured against the Area it is in.

Thank you

Ettiene

4 Replies
Highlighted
MVP
MVP

Re: Line Graph with 2 dimensions and 1 measure over time

Would you be able to share some raw data behind this sort of output?

ogster1974
Honored Contributor II

Re: Line Graph with 2 dimensions and 1 measure over time

Have you tried using the reference line for your Area?

roharoha
Valued Contributor III

Re: Line Graph with 2 dimensions and 1 measure over time

use month as dimension and 2 expression each one with defined dimension via set analysis

dwforest
Valued Contributor

Re: Line Graph with 2 dimensions and 1 measure over time

Depending on how you data is organized, you can either have 2 Dimensions (Month, Shop) with a measure of sales or as Robin indicates, 1 Dimension and 2 measures, one for each shop.

The first method would automatically acccomodate a 3rd shop....