Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Line chart of Expressions separated by Dimension

Good Morning Everyone,

Intro

The company I am working for is looking to transition from Tableau to QlikView and potentially onto QlikSense. My role is to get up to speed with QlikView and to do a review on QlikView Vs Tableau, highlighting the benefits and drawbacks to both. At the moment I am really enjoying the ability of QlikView to easily drill down and search through big data sets.

The Question

The data below is a sample of a larger SQL table containing Manufacturing ID, Manufacturing Date and 6xTemperature measures.

TempX columns display temperature differentials from a set point throughout manufacturing.

SetPoint 1- Start production  --> SetPoint 6 -End production

As you can see several rows have the same manufacturing ID, e.g ID 394337 appears in the first four rows.


I would like to plot the average temperature profile for each ID. (See Tableau Chart)


As an example of what I am trying to achieve I have included the Tableau counter chart, I don't believe I have enough Qlik expertise to replicate this. All advice would be greatly appreciated. I have attached the QlikView document.

Thanks
Steve

Sample Table.

IDDateTemp1Temp2Temp3Temp4Temp5Temp6
394333704/01/2016-0.3200.490.841.932.67
394333704/01/2016-0.3200.490.841.932.67
394333704/01/2016-0.3200.490.841.932.67
394333704/01/2016-0.3200.490.841.932.67
394333804/01/20160.511.221.191.452.093.5
394333804/01/20160.511.221.191.452.093.5
394333804/01/20160.511.221.191.452.093.5
394333804/01/20160.511.221.191.452.093.5
394334204/01/2016-1.34-0.65-0.30.150.71.21
394334204/01/2016-1.34-0.65-0.30.150.71.21
394334204/01/2016-1.34-0.65-0.30.150.71.21
394334204/01/2016-1.34-0.65-0.30.150.71.21
394333905/01/20160.270.970.640.713.312.56
394333905/01/20160.270.970.640.713.312.56
394333905/01/20160.270.970.640.713.312.56
394333905/01/20160.270.970.640.713.312.56
394334005/01/20160.190.241.130.752.471.58
394334005/01/20160.190.241.130.752.471.58
394334005/01/20160.190.241.130.752.471.58

Tableau chart of temp profile per manufacturing run. (note: the tableau chart does not contain the sample data, this a screenshot into the complete SQL table)

TempProfile.PNG

My Attempt..

I was unable to find a way to plot TempX along the X and then separate by ID (like in the chart above). I ended up with a continuous line chart for each Tempdiff 1,2,3 etc... 
TempProfileQlik.PNG

1 Solution

Accepted Solutions

Re: Line chart of Expressions separated by Dimension

Something like this?

Capture.PNG

Used the option to Trellis on the dimension tab

Capture.PNG

And transformation of your data model:

CrossTable(TempX, Value, 2)

LOAD ID,

     Date,

     Temp1,

     Temp2,

     Temp3,

     Temp4,

     Temp5,

     Temp6

FROM

[https://community.qlik.com/thread/220930]

(html, codepage is 1252, embedded labels, table is @1);

2 Replies

Re: Line chart of Expressions separated by Dimension

Something like this?

Capture.PNG

Used the option to Trellis on the dimension tab

Capture.PNG

And transformation of your data model:

CrossTable(TempX, Value, 2)

LOAD ID,

     Date,

     Temp1,

     Temp2,

     Temp3,

     Temp4,

     Temp5,

     Temp6

FROM

[https://community.qlik.com/thread/220930]

(html, codepage is 1252, embedded labels, table is @1);

Not applicable

Re: Line chart of Expressions separated by Dimension

Hi Sunny,

That's exactly what I was looking for!!

Thank you

Community Browser