Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

QV Doc

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

2 Replies
stabben23
Partner - Master
Partner - Master

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
Creator II
Creator II
Author

Hi

Thanks

Then the Premium and NCB columns returns zero vaues