topic Previous Period in QlikView https://community.qlik.com/t5/QlikView/Previous-Period/m-p/40145#M6764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>I know it's a common question here but I need some help to get the value of previous period.</P><P></P><P></P><P>I have the requirement to show the value of previous period on a table with a month attribute and dependent of list boxes of Year, Month, Week, Day.</P><P></P><P>Do you have some example? I only saw examples with month.</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 700px;"><TBODY><TR><TD height="19" style="border: 0.5pt solid windowtext; border-image: none;" width="88"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">Month</SPAN></TD><TD colspan="2" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="279"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">jan-18</SPAN></TD><TD colspan="2" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="333"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">feb-18</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">Sales</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">Sales (Previous Period)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">Sales</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">Sales (Previous Period)</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;"> </SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">100</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">72</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">59</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">98</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>(If I have in a list box a selection of 08/01/2018 it suppose to show the value of 08/01/2017 in Sales (Previous Period).</P><P></P><P>Thanks,</P><P></P><P>Pedro</P></BODY></HTML> Mon, 16 Apr 2018 09:39:01 GMT Anonymous 2018-04-16T09:39:01Z Previous Period https://community.qlik.com/t5/QlikView/Previous-Period/m-p/40145#M6764 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>I know it's a common question here but I need some help to get the value of previous period.</P><P></P><P></P><P>I have the requirement to show the value of previous period on a table with a month attribute and dependent of list boxes of Year, Month, Week, Day.</P><P></P><P>Do you have some example? I only saw examples with month.</P><P></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> </SPAN><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">&nbsp; </SPAN></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 700px;"><TBODY><TR><TD height="19" style="border: 0.5pt solid windowtext; border-image: none;" width="88"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">Month</SPAN></TD><TD colspan="2" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="279"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">jan-18</SPAN></TD><TD colspan="2" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext black;" width="333"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">feb-18</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;"> </SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">Sales</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">Sales (Previous Period)</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">Sales</SPAN></TD><TD style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">Sales (Previous Period)</SPAN></TD></TR><TR><TD height="19" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black windowtext windowtext;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;"> </SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">100</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">72</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">59</SPAN></TD><TD align="right" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: black windowtext windowtext black;"><SPAN style="color: #000000; font-family: Verdana; font-size: 12pt;">98</SPAN></TD></TR></TBODY></TABLE><P></P><P></P><P>(If I have in a list box a selection of 08/01/2018 it suppose to show the value of 08/01/2017 in Sales (Previous Period).</P><P></P><P>Thanks,</P><P></P><P>Pedro</P></BODY></HTML> Mon, 16 Apr 2018 09:39:01 GMT https://community.qlik.com/t5/QlikView/Previous-Period/m-p/40145#M6764 Anonymous 2018-04-16T09:39:01Z