topic Re: Showing the error message whenever no records found in QlikView

Showing the error message whenever no records found

qlikviewforum — Thu, 03 Dec 2015 10:09:11 GMT

Hi,

In one of our pivot table we want to show "No records found for the selected date range" whenever there is no records found. If it possible to show this message without using the formula/expressions? Please help

Re: Showing the error message whenever no records found

tresB — Thu, 03 Dec 2015 10:26:56 GMT

Use the condition (record/field value count=0) as 'Calculation Condition'
Select 'Calculation condition unfulfilled' in error message
write your desired message

Re: Showing the error message whenever no records found

Anonymous — Thu, 03 Dec 2015 10:28:06 GMT

this may help you..

see the attachment

Re: Showing the error message whenever no records found

qlikviewforum — Thu, 03 Dec 2015 10:39:13 GMT

I don't to use the same expression in the calculation to check whether the count is zero or not since expression is complex and taking too much time since the data volume is more. Is there is anyway to the message when there is no records found.

Re: Showing the error message whenever no records found

qlikviewforum — Thu, 03 Dec 2015 10:42:20 GMT

Thank You! I tried it but it is not showing any message.

Re: Showing the error message whenever no records found

tresB — Thu, 03 Dec 2015 10:45:59 GMT

If you just copy the same expression and paste in another place, qv doesn't re-calculate it but reuse the calculated value from cache (but is has to be exact match, refer :The QlikView Cache for maore info). Hence, you can use the same expression.

Re: Showing the error message whenever no records found

avinashelite — Thu, 03 Dec 2015 10:50:50 GMT

could you please share your file ..will check whats the issue

Re: Showing the error message whenever no records found

Anonymous — Thu, 03 Dec 2015 10:59:17 GMT

Could you post a sample?

Re: Showing the error message whenever no records found

Kushal_Chawda — Thu, 03 Dec 2015 11:21:37 GMT

1) Create the text object on top of the chart with required message.

2) Set text object layer as Top & chart layer as Normal (See Layout tab)

2) Now put your calculation expression like below in Conditional (In layout tab of text object).

=if( YourExpression =0, 1,0)

So when condition is satisfied, text object will appear with message else text object will be hidden

Re: Showing the error message whenever no records found

qlikviewforum — Thu, 03 Dec 2015 11:28:53 GMT

Sorry I cannot attach QVW file due to security reasons. You may take any charts as an example try to show any message whenever no records exists for the selected date range.

Re: Showing the error message whenever no records found

qlikviewforum — Thu, 03 Dec 2015 11:36:24 GMT

We have this solution already but we dont wish to add any extra objects in our application. Is it possible to show it in the chart itself?

Re: Showing the error message whenever no records found

Kushal_Chawda — Thu, 03 Dec 2015 11:38:16 GMT

then only option available is what tresesco has suggested.