topic Re: Dates in QlikView https://community.qlik.com/t5/QlikView/Dates/m-p/1434109#M431007 <HTML><HEAD></HEAD><BODY><P>Group By might not be required, right?</P></BODY></HTML> Wed, 11 Oct 2017 10:16:25 GMT tresB 2017-10-11T10:16:25Z Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1434106#M431004 <HTML><HEAD></HEAD><BODY><P>Hi Everyone </P><P></P><P>i have a datasource in that data i want to flag dates&nbsp; where system are on peak ( between 24 &amp; 4)&nbsp; and off-peak ( between 5 &amp; 23) so i want to flag them for every month . please help </P><P></P><P></P><P>thank you in advance </P></BODY></HTML> Wed, 11 Oct 2017 10:09:31 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1434106#M431004 thabo2g5 2017-10-11T10:09:31Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1434107#M431005 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P>Load *, </P><P><STRONG>If(Day(dates) &gt;= 4 and Day(dates) &lt;= 24, 'on peak', If(Day(dates) &gt;= 5 and Day(dates) &lt;= 23, 'off-peak')) as FieldName</STRONG></P><P><STRONG>Group By <STRONG style="font-size: 13.3333px;">dates;</STRONG></STRONG></P></BODY></HTML> Wed, 11 Oct 2017 10:13:30 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1434107#M431005 Anil_Babu_Samineni 2017-10-11T10:13:30Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1434108#M431006 <HTML><HEAD></HEAD><BODY><P>Can you please elaborate?</P></BODY></HTML> Wed, 11 Oct 2017 10:15:42 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1434108#M431006 Kushal_Chawda 2017-10-11T10:15:42Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1434109#M431007 <HTML><HEAD></HEAD><BODY><P>Group By might not be required, right?</P></BODY></HTML> Wed, 11 Oct 2017 10:16:25 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1434109#M431007 tresB 2017-10-11T10:16:25Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1434110#M431008 <HTML><HEAD></HEAD><BODY><P>May be, But the reason i state the Group By here is recently i've faced issue with Unique dates so then i thought to use..</P></BODY></HTML> Wed, 11 Oct 2017 10:18:59 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1434110#M431008 Anil_Babu_Samineni 2017-10-11T10:18:59Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1434111#M431009 <HTML><HEAD></HEAD><BODY><P>But without any aggregation function 'group by' would throw error. </P></BODY></HTML> Wed, 11 Oct 2017 10:28:13 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1434111#M431009 tresB 2017-10-11T10:28:13Z Re: Dates https://community.qlik.com/t5/QlikView/Dates/m-p/1434112#M431010 <HTML><HEAD></HEAD><BODY><P>Again true, I feel it like using Aggregation only. thanks your prompt</P></BODY></HTML> Wed, 11 Oct 2017 10:30:58 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/1434112#M431010 Anil_Babu_Samineni 2017-10-11T10:30:58Z