topic Multiple Time Periods with different dates - how? in QlikView https://community.qlik.com/t5/QlikView/Multiple-Time-Periods-with-different-dates-how/m-p/1152659#M462818 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a tricky one. I got two KPIs lets say "<STRONG>sales</STRONG>" and "<STRONG>accidents</STRONG>". I have defined 4 time periods "current", "before", "previous" and "year on year". And i have data per calendar week.</P><P></P><P>Now the definition of what is current, before and so on can change.</P><P></P><P>For "<STRONG>sales</STRONG>" Current is: </P><P>CW15 - 2016 </P><P>CW16 - 2016</P><P></P><P>and for "<STRONG>accidents</STRONG>" Current is:</P><P>CW16 - 2016</P><P>CW17 - 2016</P><P></P><P>same for the other pediods in the past - e.g.:</P><P></P><P>For "<STRONG>sales</STRONG>" previous is: </P><P>CW01 - 2016 </P><P>CW02 - 2016</P><P></P><P>and for "<STRONG>accidents</STRONG>" previous is:</P><P>CW02 - 2016</P><P>CW03 - 2016</P><P></P><P>In the Dashboard I want obviously only show one listbox where the user can select a time period as filter option.</P><P></P><P>How do i do this?</P><P></P><P>Before i had multiple values for multiple time perdiods i just had a mapping table (see below)</P><P></P><P>Now how could i do this? Adjusting calculation formulars by set analysis would not be an issue</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">CW</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Period</TH></TR><TR><TD style="padding: 2px;">CW15 - 2016</TD><TD style="padding: 2px;">Current</TD></TR><TR><TD style="padding: 2px;">CW16 - 2016</TD><TD style="padding: 2px;">Current</TD></TR><TR><TD style="padding: 2px;">CW01 - 2016</TD><TD style="padding: 2px;">Previous</TD></TR><TR><TD>...</TD><TD>...</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 23 Aug 2016 06:54:51 GMT 2016-08-23T06:54:51Z Multiple Time Periods with different dates - how? https://community.qlik.com/t5/QlikView/Multiple-Time-Periods-with-different-dates-how/m-p/1152659#M462818 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a tricky one. I got two KPIs lets say "<STRONG>sales</STRONG>" and "<STRONG>accidents</STRONG>". I have defined 4 time periods "current", "before", "previous" and "year on year". And i have data per calendar week.</P><P></P><P>Now the definition of what is current, before and so on can change.</P><P></P><P>For "<STRONG>sales</STRONG>" Current is: </P><P>CW15 - 2016 </P><P>CW16 - 2016</P><P></P><P>and for "<STRONG>accidents</STRONG>" Current is:</P><P>CW16 - 2016</P><P>CW17 - 2016</P><P></P><P>same for the other pediods in the past - e.g.:</P><P></P><P>For "<STRONG>sales</STRONG>" previous is: </P><P>CW01 - 2016 </P><P>CW02 - 2016</P><P></P><P>and for "<STRONG>accidents</STRONG>" previous is:</P><P>CW02 - 2016</P><P>CW03 - 2016</P><P></P><P>In the Dashboard I want obviously only show one listbox where the user can select a time period as filter option.</P><P></P><P>How do i do this?</P><P></P><P>Before i had multiple values for multiple time perdiods i just had a mapping table (see below)</P><P></P><P>Now how could i do this? Adjusting calculation formulars by set analysis would not be an issue</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">CW</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Period</TH></TR><TR><TD style="padding: 2px;">CW15 - 2016</TD><TD style="padding: 2px;">Current</TD></TR><TR><TD style="padding: 2px;">CW16 - 2016</TD><TD style="padding: 2px;">Current</TD></TR><TR><TD style="padding: 2px;">CW01 - 2016</TD><TD style="padding: 2px;">Previous</TD></TR><TR><TD>...</TD><TD>...</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 23 Aug 2016 06:54:51 GMT https://community.qlik.com/t5/QlikView/Multiple-Time-Periods-with-different-dates-how/m-p/1152659#M462818 2016-08-23T06:54:51Z