topic Re: Remove unwanted value in QlikView https://community.qlik.com/t5/QlikView/Remove-unwanted-value/m-p/341131#M126037 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I believe you need to give command separately for both headers like below</P><P></P><P>WK as Week_Name</P><P>Week(Op_Date) as Week_Name</P><P></P><P>I hope it would help you.</P><P></P><P>Regards</P><P>Nikhil</P></BODY></HTML> Tue, 07 Aug 2012 05:57:56 GMT 2012-08-07T05:57:56Z Remove unwanted value https://community.qlik.com/t5/QlikView/Remove-unwanted-value/m-p/341130#M126036 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have code like below, when i reload this, i get WK as default. </P><P></P><P>'WK ' &amp; Week(Op_Date) as Week_Name,</P><P></P><P>I want to remove this.</P><P></P><P>Regards</P><P>Renjith</P></BODY></HTML> Tue, 07 Aug 2012 05:38:36 GMT https://community.qlik.com/t5/QlikView/Remove-unwanted-value/m-p/341130#M126036 renjithpl 2012-08-07T05:38:36Z Re: Remove unwanted value https://community.qlik.com/t5/QlikView/Remove-unwanted-value/m-p/341131#M126037 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I believe you need to give command separately for both headers like below</P><P></P><P>WK as Week_Name</P><P>Week(Op_Date) as Week_Name</P><P></P><P>I hope it would help you.</P><P></P><P>Regards</P><P>Nikhil</P></BODY></HTML> Tue, 07 Aug 2012 05:57:56 GMT https://community.qlik.com/t5/QlikView/Remove-unwanted-value/m-p/341131#M126037 2012-08-07T05:57:56Z Re: Remove unwanted value https://community.qlik.com/t5/QlikView/Remove-unwanted-value/m-p/341132#M126038 <HTML><HEAD></HEAD><BODY><P>Hi renjitpl,</P><P></P><P>can you please ellaborate your question.....</P></BODY></HTML> Tue, 07 Aug 2012 06:25:24 GMT https://community.qlik.com/t5/QlikView/Remove-unwanted-value/m-p/341132#M126038 senpradip007 2012-08-07T06:25:24Z Re: Remove unwanted value https://community.qlik.com/t5/QlikView/Remove-unwanted-value/m-p/341133#M126039 <HTML><HEAD></HEAD><BODY><P>I have used following code for my query, It works </P><P></P><P>IF(len(trim('WK ' &amp; Week(Op_Date)))&gt;3, 'WK ' &amp; Week(Op_Date)) as Week_Name</P></BODY></HTML> Tue, 14 Aug 2012 07:12:17 GMT https://community.qlik.com/t5/QlikView/Remove-unwanted-value/m-p/341133#M126039 renjithpl 2012-08-14T07:12:17Z