topic Re: Custom message for shrinked Pivot in QlikView https://community.qlik.com/t5/QlikView/Custom-message-for-shrinked-Pivot/m-p/886695#M309121 <HTML><HEAD></HEAD><BODY><P>Not a problem. I am glad this was helpful.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 09 Apr 2015 18:36:22 GMT sunny_talwar 2015-04-09T18:36:22Z Custom message for shrinked Pivot https://community.qlik.com/t5/QlikView/Custom-message-for-shrinked-Pivot/m-p/886692#M309118 <HTML><HEAD></HEAD><BODY><P>Hi Community</P><P></P><P>Does anybody know in case of no data in pivot; (pivot shrinked)</P><P></P><P>I want to add message 'No data for this selection'</P><P></P><P>Thanks</P></BODY></HTML> Thu, 09 Apr 2015 18:12:58 GMT https://community.qlik.com/t5/QlikView/Custom-message-for-shrinked-Pivot/m-p/886692#M309118 Anonymous 2015-04-09T18:12:58Z Re: Custom message for shrinked Pivot https://community.qlik.com/t5/QlikView/Custom-message-for-shrinked-Pivot/m-p/886693#M309119 <HTML><HEAD></HEAD><BODY><P>You might be able to use the calculation condition and error message to do this: Use Count(dimension) to check for calculation and use <STRONG>'No data for this selection'</STRONG> as the error message.</P><P></P><P><IMG alt="Pivot.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/83237_Pivot.PNG" style="height: auto;" /></P><P></P><P>HTH</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 09 Apr 2015 18:21:10 GMT https://community.qlik.com/t5/QlikView/Custom-message-for-shrinked-Pivot/m-p/886693#M309119 sunny_talwar 2015-04-09T18:21:10Z Re: Custom message for shrinked Pivot https://community.qlik.com/t5/QlikView/Custom-message-for-shrinked-Pivot/m-p/886694#M309120 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny for your suggestion</P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 09 Apr 2015 18:34:50 GMT https://community.qlik.com/t5/QlikView/Custom-message-for-shrinked-Pivot/m-p/886694#M309120 Anonymous 2015-04-09T18:34:50Z Re: Custom message for shrinked Pivot https://community.qlik.com/t5/QlikView/Custom-message-for-shrinked-Pivot/m-p/886695#M309121 <HTML><HEAD></HEAD><BODY><P>Not a problem. I am glad this was helpful.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 09 Apr 2015 18:36:22 GMT https://community.qlik.com/t5/QlikView/Custom-message-for-shrinked-Pivot/m-p/886695#M309121 sunny_talwar 2015-04-09T18:36:22Z