topic Re: Is it possible to make custom message when there is no data? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583326#M1109349 <HTML><HEAD></HEAD><BODY><P>try the Replace function</P></BODY></HTML> Mon, 17 Mar 2014 12:20:27 GMT 2014-03-17T12:20:27Z Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583324#M1109347 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have datasource as Excel file. The file contains two sheets. Sheet A contains data. Sheet B containd only columnnames but there is no values. i,e Sheet B is an empty sheet with out data. But the sheet will get values in coming weeks. So for now I created qvw. The qvw contains two sheets with two straight table. I would need to show to my user a custom message whenever there is no data it should show 'There is no data' with column names. If there is data it should populate with values.</P><P></P><P>Is it possible?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Mon, 17 Mar 2014 12:14:57 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583324#M1109347 2014-03-17T12:14:57Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583325#M1109348 <HTML><HEAD></HEAD><BODY><P>Please find attached qvw. I would need to show in SheetB straight table as 'There is no data' . I know if there is no data it will show 'No data to Display' in bar chart. I need now in Staright table. can anyone help me please.</P></BODY></HTML> Mon, 17 Mar 2014 12:16:27 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583325#M1109348 2014-03-17T12:16:27Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583326#M1109349 <HTML><HEAD></HEAD><BODY><P>try the Replace function</P></BODY></HTML> Mon, 17 Mar 2014 12:20:27 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583326#M1109349 2014-03-17T12:20:27Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583327#M1109350 <HTML><HEAD></HEAD><BODY><P>Thanks. How can I use replace.any example please?</P></BODY></HTML> Mon, 17 Mar 2014 12:21:27 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583327#M1109350 2014-03-17T12:21:27Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583328#M1109351 <HTML><HEAD></HEAD><BODY><P>Hi Amelia,</P><P>look at my exam app. I used and defined&nbsp; the calc condition in general tab of chart "B"</P><P></P><P>RR</P></BODY></HTML> Mon, 17 Mar 2014 12:30:23 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583328#M1109351 2014-03-17T12:30:23Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583329#M1109352 <HTML><HEAD></HEAD><BODY><P>Thanks. Perfect. Is it possible to see the same message with column names?</P></BODY></HTML> Mon, 17 Mar 2014 12:33:40 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583329#M1109352 2014-03-17T12:33:40Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583330#M1109353 <HTML><HEAD></HEAD><BODY><P>use this as an expression and the straight table should display columnname(the dimension you have chosen) and the message 'There is no data'</P><P>=Replace(Count(Distinct(Reference_SheetB)), '0', 'There is no data')</P></BODY></HTML> Mon, 17 Mar 2014 12:36:24 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583330#M1109353 2014-03-17T12:36:24Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583331#M1109354 <HTML><HEAD></HEAD><BODY><P>See attached</P><P>and you may need to do some changes like as attached</P></BODY></HTML> Mon, 17 Mar 2014 12:36:41 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583331#M1109354 sunilkumarqv 2014-03-17T12:36:41Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583332#M1109355 <HTML><HEAD></HEAD><BODY><P>No, not that way.</P><P>Workarounds maybe</P><P>- put the fieldnames into your message</P><P>- create a textbox with according message and use its showing condition on layout tab. Put the textbox over the chart B</P><P></P><P>RR</P></BODY></HTML> Mon, 17 Mar 2014 12:38:28 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583332#M1109355 2014-03-17T12:38:28Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583333#M1109356 <HTML><HEAD></HEAD><BODY><P>Hi Amelia,</P><P></P><P>you always can set a calcul condition on your object and whenever this condition doesn't apply make the application show your custom message.</P><P></P><P>You can set your custom error messages in the general tab, below the chart types in the "error messages" button.</P><P></P><P>Hope this will help you!</P><P></P><P>Cheers!</P></BODY></HTML> Mon, 17 Mar 2014 12:45:31 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583333#M1109356 alex_millan 2014-03-17T12:45:31Z Re: Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583334#M1109357 <HTML><HEAD></HEAD><BODY><P>Will something like this work?</P></BODY></HTML> Mon, 17 Mar 2014 12:49:23 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583334#M1109357 mphekin12 2014-03-17T12:49:23Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583335#M1109358 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Mon, 17 Mar 2014 13:13:56 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583335#M1109358 2014-03-17T13:13:56Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583336#M1109359 <HTML><HEAD></HEAD><BODY><P>Thanks.</P></BODY></HTML> Mon, 17 Mar 2014 13:14:11 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583336#M1109359 2014-03-17T13:14:11Z Re: Is it possible to make custom message when there is no data? https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583337#M1109360 <HTML><HEAD></HEAD><BODY><P>Thanks. This gives me more information to create Adhoc report for user. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 17 Mar 2014 13:15:22 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make-custom-message-when-there-is-no-data/m-p/583337#M1109360 2014-03-17T13:15:22Z