Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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
Contributor III
Contributor III

any help