topic Period pivot table in QlikView https://community.qlik.com/t5/QlikView/Period-pivot-table/m-p/1158667#M377751 <HTML><HEAD></HEAD><BODY><P>Dear Experts, </P><P></P><P>Is there a way we can achieve the following ? :</P><P>The table goes by Report Date(transaction date) as the dimension and the measures are to be the sales on that day(row) and the sales of previous month on same day. So for an example, the first row we see below is 20/4/2016 which carries its value in column sales, in column sales last month, we are expecting the sales of 20/3/2016. Is this possible in a table that carries the date itself as the dimension? I know it is possible with any other dimension, but this case is tricky to solve.</P><P></P><P><IMG alt="sample.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127357_sample.png" style="height: auto;" /></P><P></P><P>Kindly Help.</P><P>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Thu, 09 Jun 2016 08:23:03 GMT ramanannad 2016-06-09T08:23:03Z Period pivot table https://community.qlik.com/t5/QlikView/Period-pivot-table/m-p/1158667#M377751 <HTML><HEAD></HEAD><BODY><P>Dear Experts, </P><P></P><P>Is there a way we can achieve the following ? :</P><P>The table goes by Report Date(transaction date) as the dimension and the measures are to be the sales on that day(row) and the sales of previous month on same day. So for an example, the first row we see below is 20/4/2016 which carries its value in column sales, in column sales last month, we are expecting the sales of 20/3/2016. Is this possible in a table that carries the date itself as the dimension? I know it is possible with any other dimension, but this case is tricky to solve.</P><P></P><P><IMG alt="sample.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/127357_sample.png" style="height: auto;" /></P><P></P><P>Kindly Help.</P><P>Thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Thu, 09 Jun 2016 08:23:03 GMT https://community.qlik.com/t5/QlikView/Period-pivot-table/m-p/1158667#M377751 ramanannad 2016-06-09T08:23:03Z