Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Kitting info

Hello All,

Thanks in advance for tthe support, i have a problem, i have to reproduce the function that i have in SQL in QLiksense someone could help me?

Below the sql formule:

SELECT COALESCE(k.linked_request_unit_id,k.request_unit_id) AS request_unit_id

, CASE

WHEN k.ing_kitting_product_id IS NOT NULL AND k.linked_request_unit_id IS NULL then 'MASTER'

WHEN k.ing_kitting_product_id IS NOT NULL AND k.linked_request_unit_id IS NOT NULL then 'PART KIT'

ELSE N'#' END AS [Master/Part]

  INTO #kitting_product

  FROM ing_kitting_product k

thanks again

Massimiliano

Tags (1)
Community Browser