topic Re: Conditions in count not working in QlikView

Conditions in count not working

Wed, 09 Sep 2015 06:50:32 GMT

Good day,

I tried this piece of code, and my filters are not working, please assist:

count(if(PRODUCT_CODE='MLOAN' and REG_LAST_3MONTHS_IND='Y' and match(MLOANS_BANDS_CODE,'A','B','C','D','E','F'),FINAL_ML_AMT))

sunny_talwar — Wed, 09 Sep 2015 06:54:08 GMT

Try this with set analysis may be:

=Count({<PRODUCT_CODE = {'MLOAN'}, REG_LAST_3MONTHS_IND = {'Y'}, MLOANS_BANDS_CODE = {'A', 'B', 'C', 'D', 'E', 'F'}>} FINAL_ML_AMT)

Wed, 09 Sep 2015 07:47:08 GMT

Thanks a lot its working like a charm

sunny_talwar — Wed, 09 Sep 2015 07:58:09 GMT

Awesome

I am glad it worked. I would suggest closing this thread by marking the correct answer.

Best,

Sunny