topic Re: If condition in QlikView https://community.qlik.com/t5/QlikView/If-condition/m-p/961979#M330052 <HTML><HEAD></HEAD><BODY><P>Hi Naveen,</P><P></P><P>You can try 'Ceil (datefieldname / 7)' as Weeknumber and use this 'Weeknumber' field in your charts.</P><P></P><P>Hope this will be helpful.</P></BODY></HTML> Mon, 26 Oct 2015 10:55:30 GMT prashantbaste 2015-10-26T10:55:30Z If condition https://community.qlik.com/t5/QlikView/If-condition/m-p/961977#M330050 <HTML><HEAD></HEAD><BODY><P>I have Date field in the table</P><P>I did some calculation like weekstart(Date) as call_week</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/103039_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>now I need to show ' W1' in the place of 1-oct-2015&nbsp; next 'W2' in the place of 14-oct-2015</P></BODY></HTML> Mon, 26 Oct 2015 10:39:29 GMT https://community.qlik.com/t5/QlikView/If-condition/m-p/961977#M330050 2015-10-26T10:39:29Z Re: If condition https://community.qlik.com/t5/QlikView/If-condition/m-p/961978#M330051 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>....</P><P></P><P>NewTable:</P><P>LOAD *,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 'W' &amp; Autonumber(call_week,'WeekNum') as WeekNum</P><P>RESIDENT YourTable</P><P>ORDER BY call_week ASC;</P><P></P><P>DROP TABLE YourTable;</P></BODY></HTML> Mon, 26 Oct 2015 10:44:52 GMT https://community.qlik.com/t5/QlikView/If-condition/m-p/961978#M330051 swuehl 2015-10-26T10:44:52Z Re: If condition https://community.qlik.com/t5/QlikView/If-condition/m-p/961979#M330052 <HTML><HEAD></HEAD><BODY><P>Hi Naveen,</P><P></P><P>You can try 'Ceil (datefieldname / 7)' as Weeknumber and use this 'Weeknumber' field in your charts.</P><P></P><P>Hope this will be helpful.</P></BODY></HTML> Mon, 26 Oct 2015 10:55:30 GMT https://community.qlik.com/t5/QlikView/If-condition/m-p/961979#M330052 prashantbaste 2015-10-26T10:55:30Z