Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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);

View solution in original post

2 Replies
sunny_talwar

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
Author

Hi Sunny,

That's exactly what I was looking for!!

Thank you