topic Kitting info in App Development https://community.qlik.com/t5/App-Development/Kitting-info/m-p/1380319#M31357 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>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?</P><P></P><P>Below the sql formule:</P><P></P><P>SELECT COALESCE(k.linked_request_unit_id,k.request_unit_id) AS request_unit_id</P><P>, CASE </P><P>WHEN k.ing_kitting_product_id IS NOT NULL AND k.linked_request_unit_id IS NULL then 'MASTER'</P><P>WHEN k.ing_kitting_product_id IS NOT NULL AND k.linked_request_unit_id IS NOT NULL then 'PART KIT'</P><P>ELSE N'#' END AS [Master/Part]</P><P>&nbsp; INTO #kitting_product</P><P>&nbsp; FROM ing_kitting_product k</P><P></P><P>thanks again</P><P></P><P>Massimiliano</P></BODY></HTML> Tue, 17 Oct 2017 10:07:00 GMT 2017-10-17T10:07:00Z Kitting info https://community.qlik.com/t5/App-Development/Kitting-info/m-p/1380319#M31357 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>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?</P><P></P><P>Below the sql formule:</P><P></P><P>SELECT COALESCE(k.linked_request_unit_id,k.request_unit_id) AS request_unit_id</P><P>, CASE </P><P>WHEN k.ing_kitting_product_id IS NOT NULL AND k.linked_request_unit_id IS NULL then 'MASTER'</P><P>WHEN k.ing_kitting_product_id IS NOT NULL AND k.linked_request_unit_id IS NOT NULL then 'PART KIT'</P><P>ELSE N'#' END AS [Master/Part]</P><P>&nbsp; INTO #kitting_product</P><P>&nbsp; FROM ing_kitting_product k</P><P></P><P>thanks again</P><P></P><P>Massimiliano</P></BODY></HTML> Tue, 17 Oct 2017 10:07:00 GMT https://community.qlik.com/t5/App-Development/Kitting-info/m-p/1380319#M31357 2017-10-17T10:07:00Z