5 Replies Latest reply: Mar 11, 2016 1:59 PM by Gysbert Wassenaar RSS

    Loading Data from SQL Server

    David Boyd

      I am trying to replicate a dashboard that we have on another platform. I was able to import the data but I am having problems with parsing the data. How do I get Qlik to use the correct data? Thanx in advance for any help offered.

       

      The fields that I'm using are:

          R2MCU,

          R2DCTO,

          R2TQTY,

          R2PSTB,

          R2DTPT

       

      and the SQL statement from the existing dashboard is:

       

      SELECT DISTINCT 

        COUNT( DISTINCT R2URAB ) AS COLUMN0000,

        COUNT( * ) AS COLUMN0001,

        SUM( R2TQTY ) / 100 AS COLUMN0002

      FROM

        DCLINK.dbo.F4611 F4611

      WHERE

        R2TYFL = '2'

          AND R2MCU = '          20'

        AND R2DTPT =(

        SELECT

        max( F4611.R2DTPT )

        FROM

        F4611 F4611

        )

        AND R2PSTB = '340'

        AND R2DCTO NOT IN( 'SU', 'SY', 'SP', 'SR', 'S5', 'S1', 'S2', 'SE', 'SJ', 'SH', 'SZ' )