Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Need Assistance.

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,

1 Solution

Accepted Solutions
PrashantSangle

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,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

2 Replies
jaumecf23
Creator III
Creator III

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)

PrashantSangle

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,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post