Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mohammadkhatimi
Partner - Specialist
Partner - Specialist

I want those entries who has booked & Cancelled..

Hi Everyone,

I want those entries who has booked and cancelled the policy no, with the same pass port number and same issuer name..

But i don't want those entries who has booked and cancelled with the same passport name...and booked it again..

For e.g

Pass port number: 707106899

Supriya Dutta should be considered not Susmita Goswami..

PFA

1 Solution

Accepted Solutions
karthiksrqv
Partner - Creator II
Partner - Creator II

Hi,

Please try this:

=

if(

(

count(TOTAL <PASSPORT_NO,[Issued By]> {<[STATUS OF POLICY]={"Booked"}>} [STATUS OF POLICY])

=

count(TOTAL <PASSPORT_NO,[Issued By]> {<[STATUS OF POLICY]={"Cancelled"}>} [STATUS OF POLICY])

)

,

sum(Base)+sum(Tax)

)

View solution in original post

5 Replies
neha_shirsath
Specialist
Specialist

Hi Mohammad,

What is Req_date here?

Because it is not changing with Issued by list box,so the both dates are for both Dutta & Goswami?

Thanks,

Neha

karthiksrqv
Partner - Creator II
Partner - Creator II

Hi,

Please try this:

=

if(

(

count(TOTAL <PASSPORT_NO,[Issued By]> {<[STATUS OF POLICY]={"Booked"}>} [STATUS OF POLICY])

=

count(TOTAL <PASSPORT_NO,[Issued By]> {<[STATUS OF POLICY]={"Cancelled"}>} [STATUS OF POLICY])

)

,

sum(Base)+sum(Tax)

)

tresesco
MVP
MVP

May be like in attached sample.

Expression :

=sum({<[Issued By]={"=Count({<[STATUS OF POLICY]={'BOOKED'}>}[STATUS OF POLICY])=1"}>

  *

  <[Issued By]={"=Count({<[STATUS OF POLICY]={'CANCELLED'}>}[STATUS OF POLICY])=1"}>

  } Base)

+

sum( {<[Issued By]={"=Count({<[STATUS OF POLICY]={'BOOKED'}>}[STATUS OF POLICY])=1"}>

  *

  <[Issued By]={"=Count({<[STATUS OF POLICY]={'CANCELLED'}>}[STATUS OF POLICY])=1"}>

  }Tax)

mohammadkhatimi
Partner - Specialist
Partner - Specialist
Author

Thanks buddy..!!

mohammadkhatimi
Partner - Specialist
Partner - Specialist
Author

Thanks for ur help..!!