topic Re: Need Assistance. in QlikView

Need Assistance.

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

Hi ,

My requirement is to transform the below expression with set analysis expression

count( DISTINCT if(Deal.typeOfSale <> 'Aftermarket' and ( Deal.bodyInsuranceIncomeTick <> '0' or Deal.compInsuranceIncomeTick <> '0' or Deal.depositCoverIncomeTick <> '0' or Deal.inflationProtectorIncomeTick <> '0' ) , Deal.batch_ref))

Please kindly confirm the correct set analysis expression of the given sample -

I tried this , I am not sure about the 'and' and 'or' condition written correctly

Count(DISTINCT {<Deal.typeOfSale -= {'Aftermarket'} ,Deal.bodyInsuranceIncomeTick-={'0'} , Deal.compInsuranceIncomeTick-={'0'}, Deal.depositCoverIncomeTick-={'0'}, Deal.inflationProtectorIncomeTick-={'0'}>} Deal.batch_ref)

Thanks,

Re: Need Assistance.

jaumecf23 — Fri, 22 Jun 2018 09:36:25 GMT

I think you need to use this:

Count(DISTINCT {<Deal.typeOfSale -= {'Aftermarket'} ,Deal.bodyInsuranceIncomeTick-={'0'}>}

{<Deal.typeOfSale -= {'Aftermarket'} ,Deal.compInsuranceIncomeTick-={'0'}>}

{<Deal.typeOfSale -= {'Aftermarket'} ,Deal.depositCoverIncomeTick-={'0'}>}

{<Deal.typeOfSale -= {'Aftermarket'} ,Deal.inflationProtectorIncomeTick-={'0'}>}

Deal.batch_ref)

Re: Need Assistance.

PrashantSangle — Fri, 22 Jun 2018 09:47:56 GMT

just modifying above expression

Count(DISTINCT {<Deal.typeOfSale -= {'Aftermarket'} ,Deal.bodyInsuranceIncomeTick-={'0'}>

<Deal.typeOfSale -= {'Aftermarket'} ,Deal.compInsuranceIncomeTick-={'0'}>

<Deal.typeOfSale -= {'Aftermarket'} ,Deal.depositCoverIncomeTick-={'0'}>

<Deal.typeOfSale -= {'Aftermarket'} ,Deal.inflationProtectorIncomeTick-={'0'}>}

Deal.batch_ref)

Regards,