This content has been marked as final. Show 5 replies
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:
and the SQL statement from the existing dashboard is:
COUNT( DISTINCT R2URAB ) AS COLUMN0000,
COUNT( * ) AS COLUMN0001,
SUM( R2TQTY ) / 100 AS COLUMN0002
R2TYFL = '2'
AND R2MCU = ' 20'
AND R2DTPT =(
max( F4611.R2DTPT )
AND R2PSTB = '340'
AND R2DCTO NOT IN( 'SU', 'SY', 'SP', 'SR', 'S5', 'S1', 'S2', 'SE', 'SJ', 'SH', 'SZ' )