Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

How to ignore same unique record being considered for the intended logic

Dear All,

There are some records among them some are repeated twice. one of them has  B/CF  grater than zero  while other record with B/CF more than zero. If I need to select records of which B/CF =0  but  C/B >0, the above record too is coming. How should the expression  be modified to ignore the below record which has a B/CF >0  at one of its row.

BR_CODECLAIM NUMBERB/BFPROVISIONPAIDADJUSTMENTB/CFRECVERY_TYPEO/BMNRECEIVEDC/B
RACLRA001A000252500000025000FOREIGN4500004500
RACLRA001A000250 000REINSURANCE6500006500

 

 

Expression used as follows:

SUM({<[B/CF]={"=[B/CF]=0"},[C/B]={"=[C/B]>0"}>}[C/B])

Thanks in advance

Neville

1 Solution

Accepted Solutions
MayilVahanan

Hi @nevilledhamsiri 

Try like this

SUM({<[CLAIM NUMBER]={"=Sum([B/CF])=0 and Sum([C/B])>0"}>}[C/B])

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

5 Replies
Chanty4u
MVP
MVP

Try this

SUM({<isnull([B/CF])=0},[C/B]={">0"}>}[C/B])

nevilledhamsiri
Specialist
Specialist
Author

Looks like it doesn't work. There is an error in the formula .could you please test it & send?

 

MayilVahanan

Hi @nevilledhamsiri 

Try like this

SUM({<[CLAIM NUMBER]={"=Sum([B/CF])=0 and Sum([C/B])>0"}>}[C/B])

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Vegar
MVP
MVP

It looks like you can simplify your expression. This should work. 

=SUM( {<[B/CF]={"0"},[C/B]={">0"}>} [C/B])

nevilledhamsiri
Specialist
Specialist
Author

Dear Vahanam

Thank for the formula which helped me to resolve my issue. The good thing about is that even if the B/CF carries a null value, still the expected out put is produced.

Regards

Neville