topic Re: Hide Straight Table if no row return in QlikView

Hide Straight Table if no row return

Tue, 03 Sep 2013 01:30:40 GMT

Dear All,

Is there any way to hide the straight table if there is no row return for the selection.

Below is the screenshot. I would like to hide the table completely if no record found. Thank you

Re: Hide Straight Table if no row return

amars — Tue, 03 Sep 2013 01:47:10 GMT

Hi,

In Straight Table Properties -> Layout Tab -> Show click on Conditional and in the text box use a condition like

Count(KeyField in the Straight Table).

In case it returns 0 the chart will be hidden otherwise it will show.

Thanks....

Re: Hide Straight Table if no row return

Tue, 03 Sep 2013 02:07:40 GMT

I have put this in the condition.

But no changes and the table still showing.

any clue?

Count(b_FullName)>0

Re: Hide Straight Table if no row return

amars — Tue, 03 Sep 2013 04:35:30 GMT

Can you share the sample application?

Re: Re: Hide Straight Table if no row return

Tue, 03 Sep 2013 05:10:08 GMT

hi michael.

There are two table on left and right. The second one is without the data at the moment. i want the header to be hidden automatically whenever there is not row. Please help thank you