topic QV Doc in QlikView

QV Doc

upaliwije — Sat, 05 Sep 2015 20:05:05 GMT

Hi Friends

I have an issue in my QV doc with large data. I have attached my QV doc with sample data Pls help me to solve my problem

stabben23 — Sat, 05 Sep 2015 20:20:51 GMT

Hi,

add CLAIM_NO={'*'} in all your expression like this:

SUM({<CLAIM_NO={'*'}>}CRE_PAID_AMOUNT)

sum({<CLAIM_NO={'*'}>}if(isnull(DESC),PREMIUM,AMOUNT))

sum({$<DESC={'NO CLAIM BONUS'}, CLAIM_NO={'*'}>}AMOUNT)

upaliwije — Sun, 06 Sep 2015 02:50:07 GMT

Thanks

Then the Premium and NCB columns returns zero vaues