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: 
Not applicable

Conditions in count not working

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))

3 Replies
sunny_talwar

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)

Not applicable
Author

Thanks a lot its working like a charm

sunny_talwar

Awesome

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

Best,

Sunny