How to convert Sql code to Qlikview code

[Naps_230]

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,

[sidhiq91]

@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.