Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
subash29
Contributor III
Contributor III

no row in table box to show "no display found"

how can we do while selecting list items when table box has no row it returns "no display found"

8 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

In Table Box->Properties->General, add a Calculation Condition (bottom left). Next, customize the Calculation Condition Unfulfilled message to your taste after pressing the Error Messages... button.

Good luck,

Peter

subash29
Contributor III
Contributor III
Author

its not working

On Tue, Apr 21, 2015 at 3:11 PM, Peter Cammaert <qcwebmaster@qlikview.com>

awhitfield
Partner - Champion
Partner - Champion

Hi Raj,

See the attached with calculation condition of GetSelectedCount(ABC) > 0  and Custom Error Message of '

No Display Found

Regards

Andy

subash29
Contributor III
Contributor III
Author

When No data selection it show NO data found.its too not working

On Tue, Apr 21, 2015 at 5:38 PM, Andrew Whitfield <qcwebmaster@qlikview.com>

awhitfield
Partner - Champion
Partner - Champion

Shows up like this here!160957.png

which clearly shows 'Ni Display Found'!

Andy

subash29
Contributor III
Contributor III
Author

When i selecting the Values if table Box has no data To show That time only

i want to Show "NO data Display".

On Tue, Apr 21, 2015 at 6:54 PM, Andrew Whitfield <qcwebmaster@qlikview.com>

awhitfield
Partner - Champion
Partner - Champion

You need to amend the Calculation expression to match your requirement and then enter you customer Error Message.

If you can't figure it out, then post an example app..

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Do the steps as detailed in Re: pivot and straight table‌ except for the last one (do NOT set the Conditional Show condition).

In the macro, change the chart symbol (currently "CH01" in the GetSheetObject() call which identifies an imaginary chart) into the one associated with your table box. See Table Box->Properties->General->Object ID

Then add the following condition to the Calculation condition field in Table Box->Properties->General:

$(vRowsCH01) > 0

Best,

Peter