topic Re: How to change the message instead of no data to display in QlikView https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2846#M793515 <HTML><HEAD></HEAD><BODY><P>Hi Devarasu,</P><P></P><P>Thanks, it helps upto some extent. But the problem is the chart is not showing any data even if we select the year where the data was there.</P><P></P><P>Eg: If there was no data for 2017- it shows my custom message but for 2018( we have data) it populates the same message instead of showing the data.</P><P></P><P>Regards,</P><P>Puneet Agarwal</P></BODY></HTML> Mon, 22 Jan 2018 06:36:26 GMT puneetagarwal 2018-01-22T06:36:26Z How to change the message instead of no data to display https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2840#M793509 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Hi,</SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a Bar chart and when I am clicking on any selection based on selection the data is changing and when there is no relevant data it is showing<STRONG style="font-style: inherit; font-family: inherit;"> 'No Data to Display'. </STRONG><SPAN style="font-style: inherit; font-family: inherit;">I&nbsp; want to show as </SPAN><STRONG style="font-style: inherit; font-family: inherit;">'No Transactions'</STRONG> instead of <STRONG style="font-style: inherit; font-family: inherit;">'No Data to Display'</STRONG>.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Could anyone help me how to set this as I am not aware of this earlier.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Regards,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Puneet Agarwal</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2840#M793509 puneetagarwal 2020-11-25T16:16:04Z Re: How to change the message instead of no data to display https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2841#M793510 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this:</P><P></P><P><IMG alt="barchart.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190499_barchart.png" style="height: 451px; width: 620px;" /></P><P></P><P><STRONG>==&gt; error message ==&gt; choose the first one ==&gt; add your customized message</STRONG></P></BODY></HTML> Thu, 18 Jan 2018 12:57:32 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2841#M793510 YoussefBelloum 2018-01-18T12:57:32Z Re: How to change the message instead of no data to display https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2842#M793511 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Still it is showing the same default Message 'No Data to Display'</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">P.S: I've added calculated condition as well but its not working still.</SPAN></P><P></P><P>Thanks,</P><P>Puneet</P></BODY></HTML> Thu, 18 Jan 2018 13:02:28 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2842#M793511 puneetagarwal 2018-01-18T13:02:28Z Re: How to change the message instead of no data to display https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2843#M793512 <HTML><HEAD></HEAD><BODY><P>so try to go to the sixth one and add your custom message (the sixth one is related to the calculated condition)</P></BODY></HTML> Thu, 18 Jan 2018 13:08:51 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2843#M793512 YoussefBelloum 2018-01-18T13:08:51Z Re: How to change the message instead of no data to display https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2844#M793513 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>Tried that one but it works only when the calculation is set as count(employee)=0 (It displays the custom message) </P><P>Eg: If we set count(employee)&gt;0 it&nbsp; displays default message.</P></BODY></HTML> Mon, 22 Jan 2018 06:09:06 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2844#M793513 puneetagarwal 2018-01-22T06:09:06Z Re: How to change the message instead of no data to display https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2845#M793514 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>try like this</P><P>=if(GetSelectedCount(Employee)&gt;0 and GetSelectedCount(Year)&gt;0,1,0)</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190804_Capture.JPG" style="height: 547px; width: 620px;" /></P></BODY></HTML> Mon, 22 Jan 2018 06:28:18 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2845#M793514 devarasu07 2018-01-22T06:28:18Z Re: How to change the message instead of no data to display https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2846#M793515 <HTML><HEAD></HEAD><BODY><P>Hi Devarasu,</P><P></P><P>Thanks, it helps upto some extent. But the problem is the chart is not showing any data even if we select the year where the data was there.</P><P></P><P>Eg: If there was no data for 2017- it shows my custom message but for 2018( we have data) it populates the same message instead of showing the data.</P><P></P><P>Regards,</P><P>Puneet Agarwal</P></BODY></HTML> Mon, 22 Jan 2018 06:36:26 GMT https://community.qlik.com/t5/QlikView/How-to-change-the-message-instead-of-no-data-to-display/m-p/2846#M793515 puneetagarwal 2018-01-22T06:36:26Z