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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II
‎2016-03-22 02:56 AM

INSURANCE

Hi,

I have been able to able to get output report from the data given in my attached QV document

POLICY_NOYEARPERIOD_FROMPERIOD_TORemarks
NI00111C000039201210-Feb-201209-Feb-20131ST YEAR
NI00111C000039201310-Feb-201309-Feb-20142ND YEAR
NI00111C000039201410-Feb-201409-Feb-2015NOT RENEWED
NI00111D000019201231-May-201230-May-20131ST YEAR
NI00111D000019201331-May-201330-May-2014NOT RENEWED
NI00121C000069201222-Jun-201221-Jun-20131ST YEAR
NI00121C000069201322-Jun-201321-Jun-20142ND YEAR
NI00121C000069201422-Jun-201421-Jun-20153RD YEAR
NI00121C000069201522-Jun-201521-Jun-2016LAST YEAR
NI00121D000053201223-May-201222-May-20131ST YEAR
NI00121D000053201323-May-201322-May-2014NOT RENEWED
NI00121F000014201206-Mar-201205-Mar-20131ST YEAR
NI00121F000014201306-Mar-201305-Mar-20142ND YEAR
NI00121F000014201406-Mar-201405-Mar-20153RD YEAR
NI00121F000014201506-Mar-201505-Mar-2016LAST YEAR
NI00131A000028201313-May-201312-May-20141ST YEAR
NI00131A000028201413-May-201412-May-2015NOT RENEWED
NI00141A0000041201406-Oct-201405-Oct-20151ST YEAR
NI00141A0000041201506-Oct-201505-Oct-2016LAST YEAR
NI00141C0000106201413-Oct-201412-Oct-20151ST YEAR
NI00141C0000106201513-Oct-201512-Oct-2016LAST YEAR
NI00141H0000032201410-Nov-201409-Nov-20151ST YEAR
NI00141H0000032201510-Nov-201509-Nov-2016LAST YEAR

But I need a modification to this output report as given below

POLICY_NOYEARPERIOD_FROMPERIOD_TORemarks
NI00111C000039201210-Feb-201209-Feb-20131ST YEAR
NI00111C000039201310-Feb-201309-Feb-20142ND YEAR
NI00111C000039201410-Feb-201409-Feb-20153RD YEAR
NI00111C000039201510-Feb-201509-Feb-2016NOT RENEWED
NI00111D000019201231-May-201230-May-20131ST YEAR
NI00111D000019201331-May-201330-May-20142ND YEAR
NI00111D000019201431-May-201430-May-2015NOT RENEWED
NI00121C000069201222-Jun-201221-Jun-20131ST YEAR
NI00121C000069201322-Jun-201321-Jun-20142ND YEAR
NI00121C000069201422-Jun-201421-Jun-20153RD YEAR
NI00121C000069201522-Jun-201521-Jun-2016LAST YEAR
NI00121D000053201223-May-201222-May-20131ST YEAR
NI00121D000053201323-May-201322-May-20142ND YEAR
NI00121D000053201423-May-201422-May-2015NOT RENEWED

In my requirement current not renewed records Remarks fields is replaced with next year eg 2ndYear, 3rd Year and  new record is inserted with Remars NOT RENEWD and YEAR and PERIOD FROM AND PERIOD TO  fields are advanced to corresponding Net year and next period . Newly added records are in bold letters.

Pls help me to fulfill this.

Labels (1)
Labels
test1.qvw
1,213 Views
0 Likes
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III
‎2016-03-22 05:15 AM

In response to upaliwije

No you didn't delete it. I did. You marked Vikas answer as correct so I removed my post as it was not needed. Here's the example.


talk is cheap, supply exceeds demand

View solution in original post

comm210398.qvw
1,065 Views
0 Likes
5 Replies
vikasmahajan
MVP
MVP
‎2016-03-22 03:30 AM

Attached demo see if it can help you.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Insurance_Analysis_v4.qvw
1,065 Views
0 Likes
upaliwije
Creator II
Creator II
‎2016-03-22 04:16 AM
Author

I have accidentally delete the reply Mr.Gysbert . Kindly attach the same please

1,065 Views
0 Likes
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III
‎2016-03-22 05:15 AM

In response to upaliwije

No you didn't delete it. I did. You marked Vikas answer as correct so I removed my post as it was not needed. Here's the example.


talk is cheap, supply exceeds demand
comm210398.qvw
1,066 Views
0 Likes
upaliwije
Creator II
Creator II
‎2016-03-22 05:24 AM
Author

In response to Gysbert_Wassenaar

Sorry I have marked other reply as correct by an error. Your reply matches my requirement but in my QV there are some other fields as well and I bit puzzled to to get connected to QV. I m attaching it Can you pls have look at it and advise

sample6.qvw
1,065 Views
0 Likes
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III
‎2016-03-22 11:33 AM

In response to upaliwije

I'm afraid I don't understand your question. Can you explain in more detail what problems you have?


talk is cheap, supply exceeds demand
1,065 Views
0 Likes