topic Re: Show previous month data, when there is no record in QlikView https://community.qlik.com/t5/QlikView/Show-previous-month-data-when-there-is-no-record/m-p/1374659#M459403 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>it wont work if I select only 1 period. it will show in all period<IMG alt="kd.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178607_kd.PNG" style="height: 76px; width: 620px;" /></P></BODY></HTML> Wed, 04 Oct 2017 15:38:58 GMT Anonymous 2017-10-04T15:38:58Z Show previous month data, when there is no record https://community.qlik.com/t5/QlikView/Show-previous-month-data-when-there-is-no-record/m-p/1374657#M459401 <HTML><HEAD></HEAD><BODY><P>Hey, here is the screenshot of my current pivot table (QVW file attached)</P><P></P><P><IMG alt="sample.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178210_sample.PNG" style="height: 88px; width: 620px;" /></P><P></P><P>What I am trying to achieve is something like:</P><P></P><P><IMG alt="sample2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/178247_sample2.PNG" style="height: 43px; width: 620px;" /></P><P></P><P>If it is possible, I would like to be able to do that using expression.</P><P>Does anybody have any idea? thanks before</P></BODY></HTML> Sun, 01 Oct 2017 05:14:07 GMT https://community.qlik.com/t5/QlikView/Show-previous-month-data-when-there-is-no-record/m-p/1374657#M459401 Anonymous 2017-10-01T05:14:07Z Re: Show previous month data, when there is no record https://community.qlik.com/t5/QlikView/Show-previous-month-data-when-there-is-no-record/m-p/1374658#M459402 <HTML><HEAD></HEAD><BODY><P>Hi Mike,</P><P>remove <SPAN style="color: #ff0000;">'*Avg(1)'</SPAN> from Expression.</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Sun, 01 Oct 2017 05:46:57 GMT https://community.qlik.com/t5/QlikView/Show-previous-month-data-when-there-is-no-record/m-p/1374658#M459402 antoniotiman 2017-10-01T05:46:57Z Re: Show previous month data, when there is no record https://community.qlik.com/t5/QlikView/Show-previous-month-data-when-there-is-no-record/m-p/1374659#M459403 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>it wont work if I select only 1 period. it will show in all period<IMG alt="kd.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178607_kd.PNG" style="height: 76px; width: 620px;" /></P></BODY></HTML> Wed, 04 Oct 2017 15:38:58 GMT https://community.qlik.com/t5/QlikView/Show-previous-month-data-when-there-is-no-record/m-p/1374659#M459403 Anonymous 2017-10-04T15:38:58Z