topic Re: Direct Discovery in QlikView

Direct Discovery

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please let me know how to code this in qlikview ,

CASE WHEN cs.alt_wrkr_id='Y'

THEN hw.alt_wrkr_id

ELSE 'XXXXXX' END AS alt_wrkr_id

the below sample code is working fine , but i need to add the above condtion in to the below code

DIRECT QUERY

DIMENSION

Table1.hcmcore_wrkr_key

FROM Table1.hcmcore_worker

Thanks in advance

fabio182 — Wed, 04 Jul 2018 20:18:18 GMT

Estimado, buenas tardes

Para poder añadir funciones propias de la herramienta SQL Server, tiene que hacer a través de la sentencia "native". Te comparto un ejemplo:

fact:

DIRECT QUERY

dimension

"FECHA_PROCESO_ID",

native( 'year(cast( convert(varchar(20),[FECHA_PROCESO_ID]) as date))') as ano,

"MATERIAL_PP_ID",

ORIGEN,

CENTRO,

"UNIDAD_MEDIDA"

MEASURE

"PESCA_PROPIA"

//SQL SELECT *

FROM "DWH_CORPORATIVO".OPERACIONES."FACT_PRODUCCION";

Anonymous — Thu, 05 Jul 2018 10:52:48 GMT

Hi ,

Thanks for the reply, code is useful