How to convert Sql code to Qlikview code

Naps_230 — Thu, 07 Jul 2022 04:22:00 GMT

Hi ,

Could you please help on below part, i have try from my side create Qlik code, getting issue.

SQL CODE:

CASE
WHEN MKT.mft_def_desc = 'Target Brand'
AND cstm_prod_grp_value = 'APTIOM' and P.RNK BETWEEN '1' AND '128' THEN
Sum(total_rx) else 0
END AS APTIOM_TRX,

Qlik code:

if(MKT.mft_def_desc = 'Target Brand',
if(cstm_prod_grp_value = 'APTIOM',
if(P.RNK>= 1 and P.RNK <= 128,Sum(total_rx),0))) as APTIOM_TRX,

Re: How to convert Sql code to Qlikview code

sidhiq91 — Thu, 07 Jul 2022 05:24:50 GMT

@Naps_230 Your Qlik expression would be something as below:

IF(MKT.mft_def_desc = 'Target Brand' and cstm_prod_grp_value = 'APTIOM' and (P.RNK>= 1 and P.RNK <= 128),

Sum(total_rx),0 ) as APTIOM_TRX

If this resolves your issue, kindly like and accept it as a solution.

topic How to convert Sql code to Qlikview code in App Development

How to convert Sql code to Qlikview code

Re: How to convert Sql code to Qlikview code