topic Re: Different Time Ranges in QlikView https://community.qlik.com/t5/QlikView/Different-Time-Ranges/m-p/59553#M9886 <HTML><HEAD></HEAD><BODY><P>Stefan -</P><P></P><P>Thank you. Question here would be that each season has a different start and end date, how would I account for that?</P></BODY></HTML> Tue, 20 Mar 2018 20:19:00 GMT evansabres 2018-03-20T20:19:00Z Different Time Ranges https://community.qlik.com/t5/QlikView/Different-Time-Ranges/m-p/59551#M9884 <HTML><HEAD></HEAD><BODY><P>I have sales data for several 'seasons'</P><P></P><P>There is a [Transaction Date] for each ticket sold.</P><P></P><P>What I want to do is have a time range of 0 - 100% to compare ticket sales across various seasons. </P><P></P><P>Is this possible?</P></BODY></HTML> Tue, 20 Mar 2018 20:06:53 GMT https://community.qlik.com/t5/QlikView/Different-Time-Ranges/m-p/59551#M9884 evansabres 2018-03-20T20:06:53Z Re: Different Time Ranges https://community.qlik.com/t5/QlikView/Different-Time-Ranges/m-p/59552#M9885 <HTML><HEAD></HEAD><BODY><P>Something like</P><P></P><P>LOAD </P><P>&nbsp;&nbsp;&nbsp;&nbsp; (TransactionDate - SeasonStartDate) / (SeasonEndDate - SeasonStartDate) as Percentage,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ...</P><P></P><P>??</P></BODY></HTML> Tue, 20 Mar 2018 20:15:14 GMT https://community.qlik.com/t5/QlikView/Different-Time-Ranges/m-p/59552#M9885 swuehl 2018-03-20T20:15:14Z Re: Different Time Ranges https://community.qlik.com/t5/QlikView/Different-Time-Ranges/m-p/59553#M9886 <HTML><HEAD></HEAD><BODY><P>Stefan -</P><P></P><P>Thank you. Question here would be that each season has a different start and end date, how would I account for that?</P></BODY></HTML> Tue, 20 Mar 2018 20:19:00 GMT https://community.qlik.com/t5/QlikView/Different-Time-Ranges/m-p/59553#M9886 evansabres 2018-03-20T20:19:00Z Re: Different Time Ranges https://community.qlik.com/t5/QlikView/Different-Time-Ranges/m-p/59554#M9887 <HTML><HEAD></HEAD><BODY><P>Map your Transaction dates to the season date ranges.</P><P></P><P>For example, using IntervalMatch LOAD prefix or a mapping approach.</P><P><A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2756">Don't join - use Applymap instead</A></P></BODY></HTML> Tue, 20 Mar 2018 20:24:15 GMT https://community.qlik.com/t5/QlikView/Different-Time-Ranges/m-p/59554#M9887 swuehl 2018-03-20T20:24:15Z