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: 
capriconuser
Creator
Creator

Message will displaye when click on record in qlikview

I have records like this

image

In above record you see that top 4 records assume that these 4 policies are not in previous year i.e. 2017 so this is new business .

5th and 6th records their policy no are not found in records nor in previous and not in next year this is lost business

and last 2 records p no 122 then again in next record is 122-1 this is renewed business

so from here i want to find out when P no did not found again in records then consider this lost business so i want when i click on that records then message should displayed "LOST"

this is link of folder

https://www.dropbox.com/sh/q56i4biyt8t03ow/AACfXuu5qx_5Vad0Au-YuRlia?dl=0

Labels (2)
1 Reply
capriconuser
Creator
Creator
Author

any help