topic Re: Only display straight table if rows exist in QlikView

Only display straight table if rows exist

Fri, 26 Oct 2012 19:55:06 GMT

I have a straight table with 3 columns, the first 2 are dimensions, and the third is comprised of the following expression:

sum(if(MDISKAVG >= vWarnThreshold or PDISKAVG >= vWarnThreshold,1,0))

I would like to know how to hide the table if there are no rows, i.e, when column expression calculates no values over threshold. I understand I need to put an expression in the Show Conditional in the Layout Tab, just not sure what that expression should be. Initial thought was similar expression to column 3 expression, but that one is at a per column level, not total of column.

Re: Only display straight table if rows exist

MayilVahanan — Fri, 26 Oct 2012 20:06:49 GMT

Can you provide a sample file?

Re: Only display straight table if rows exist

Anonymous — Fri, 26 Oct 2012 20:43:44 GMT

Lew,

But - did you try it? Logically it should work. When this expression is in show condition, it is calculated over all data in current slections, dimensions don't matter.

Regards,

Michael

Re: Only display straight table if rows exist

Fri, 26 Oct 2012 20:45:31 GMT

The straight table looks something like this:

SEGMENT	DISK	sum (if(MDISKAVG >= *vWarnThreshold* or PDISKAVG >= *vWarnThreshold*,1,0))
14	$FC0101	2
9	$FC9110	2
11	$FC8101	5
12	$FC2222	5

Re: Only display straight table if rows exist

MayilVahanan — Fri, 26 Oct 2012 20:56:50 GMT

Agree with mr.Michael Solomovich.

From this attached file, you can see, if sum(allowed) is less than certain value, you can hide the sheet.. but its based on selection not overall..

Re: Only display straight table if rows exist

Fri, 26 Oct 2012 22:34:56 GMT

Mayil and Michael, you were both right. I think when I first tried this I may have formed the expression incorrectly.

This one worked:

=if(sum(if(MDISKAVG >= vWarnThreshold or PDISKAVG >= vWarnThreshold,1,0))>0,1,0)

Thank you much!

Regards,

Lew