topic Re: Script Issue in QlikView https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241054#M394101 <HTML><HEAD></HEAD><BODY><P>Sorry I made a mistake. Your earlier reply is perfect</P></BODY></HTML> Sun, 13 Nov 2016 08:54:43 GMT upaliwije 2016-11-13T08:54:43Z Script Issue https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241046#M394093 <HTML><HEAD></HEAD><BODY><P>Hi friends;</P><P></P><P> I attach herewith My Qv Document and suppoting excel sheet. My output Pivot talbe is as follows</P><P></P><TABLE><TBODY><TR><TD>POLICY_NO</TD><TD>POLICY_YEAR</TD><TD>PERIOD_TO</TD><TD>ISSUE_DATE</TD><TD>I_DATE</TD><TD>C_DATE</TD><TD>CAN_DATE</TD><TD>GROSS_PREMIUM</TD><TD>REFUNDS</TD></TR><TR><TD>NM00071H000001</TD><TD>07</TD><TD>21-04-17</TD><TD>20-04-16</TD><TD>20/4/2016</TD><TD>-</TD><TD><SPAN style="color: #ff0000;">-</SPAN></TD><TD>11,696</TD><TD>0</TD></TR><TR><TD>NM00071H000001</TD><TD>07</TD><TD>21-04-17</TD><TD>-</TD><TD>-</TD><TD>30/4/2016</TD><TD>NA</TD><TD>0</TD><TD>-11,696</TD></TR><TR><TD>NM00141D0000238</TD><TD>14</TD><TD>25-03-17</TD><TD>25-03-16</TD><TD>25/3/2016</TD><TD>-</TD><TD>20/4/2016</TD><TD>13,934</TD><TD>0</TD></TR><TR><TD>NM00141D0000238</TD><TD>14</TD><TD>25-03-17</TD><TD>-</TD><TD>-</TD><TD>20/4/2016</TD><TD>NA</TD><TD>0</TD><TD>-13,934</TD></TR></TBODY></TABLE><P></P><P>In the above table CAN_DATE is blank in the very first row where as it should appear like in row number 3. Pls check my document and advise me how to correct it.</P></BODY></HTML> Sun, 13 Nov 2016 04:45:20 GMT https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241046#M394093 upaliwije 2016-11-13T04:45:20Z Re: Script Issue https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241047#M394094 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Change below code:</P><P></P><P>cdate:</P><P>Mapping load trim(POLICY_NO),trim(C_DATE)</P><P>Resident tmp;</P><P></P><P>Add where condition as below.</P><P></P><P>cdate:</P><P>Mapping load trim(POLICY_NO),trim(C_DATE)</P><P>Resident tmp where not IsNull(C_DATE) ;</P><P></P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Sun, 13 Nov 2016 07:43:11 GMT https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241047#M394094 kaushiknsolanki 2016-11-13T07:43:11Z Re: Script Issue https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241048#M394095 <HTML><HEAD></HEAD><BODY><P>Can my expert friends pls give an advice ?</P></BODY></HTML> Sun, 13 Nov 2016 07:48:18 GMT https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241048#M394095 upaliwije 2016-11-13T07:48:18Z Re: Script Issue https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241049#M394096 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Did you try the script I gave you in above post?</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Sun, 13 Nov 2016 07:50:09 GMT https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241049#M394096 kaushiknsolanki 2016-11-13T07:50:09Z Re: Script Issue https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241050#M394097 <HTML><HEAD></HEAD><BODY><P>Sorry,</P><P></P><P>I ll try and come back to you</P></BODY></HTML> Sun, 13 Nov 2016 07:54:13 GMT https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241050#M394097 upaliwije 2016-11-13T07:54:13Z Re: Script Issue https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241051#M394098 <HTML><HEAD></HEAD><BODY><P>Hi Solanki</P><P></P><P>Thanks for your advice. It is working for the sample I sent you. But when I applied it to my whole data one reord does not give the answer. I attched my excel sheet with new record. Kindly see to it and advise me pls.</P></BODY></HTML> Sun, 13 Nov 2016 08:01:34 GMT https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241051#M394098 upaliwije 2016-11-13T08:01:34Z Re: Script Issue https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241052#M394099 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>It does work.</P><P></P><P>Have a look at the attached application.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Sun, 13 Nov 2016 08:17:19 GMT https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241052#M394099 kaushiknsolanki 2016-11-13T08:17:19Z Re: Script Issue https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241053#M394100 <HTML><HEAD></HEAD><BODY><P>Yes Solanki It is working. But I add some more script some fields are blank. Eg NUMDA, AGE</P><P>Kinldy have a look at the attachment and correct me.</P></BODY></HTML> Sun, 13 Nov 2016 08:53:28 GMT https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241053#M394100 upaliwije 2016-11-13T08:53:28Z Re: Script Issue https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241054#M394101 <HTML><HEAD></HEAD><BODY><P>Sorry I made a mistake. Your earlier reply is perfect</P></BODY></HTML> Sun, 13 Nov 2016 08:54:43 GMT https://community.qlik.com/t5/QlikView/Script-Issue/m-p/1241054#M394101 upaliwije 2016-11-13T08:54:43Z