2 Replies Latest reply: Jun 16, 2016 10:06 AM by Steve Wilson RSS

    Line chart of Expressions separated by Dimension

    Steve Wilson

      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