topic Re: Qn in expression in QlikView

Qn in expression

Thu, 03 Sep 2015 16:23:27 GMT

Hi Folks,

A quick question in the staright table.

How to hide a record in the straight table when the expressions result a null value.

Regards,
Sachin

Re: Qn in expression

Oleg_Troyansky — Thu, 03 Sep 2015 16:33:23 GMT

By default, Straight Tables suppress rows that render ALL expressions as NULL or zeros. These settings are located on the Presentation tab.

It's trickier when some of the expressions render NULL and some render a value. In this case, pick one expression that's the most important and condition the rest of the expressions by the selected one. For example:

Sales = sum(Sales Amount)

Margin = IF( Sales > 0, sum(Margin))

In this example, Margin will only be displayed when Sales rendered a non-zero value.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Qn in expression

Thu, 03 Sep 2015 16:33:48 GMT

select the supress zero values and supress missing values check boxes on the presentation tab

Re: Qn in expression

Thu, 03 Sep 2015 17:19:27 GMT

I think supress zero values and supress missing values doesnt work in case of expressions right..

Re: Qn in expression

Thu, 03 Sep 2015 17:42:04 GMT

Check Surpass Zero for each dimension and expression then you wont see null values.

Re: Qn in expression

Digvijay_Singh — Thu, 03 Sep 2015 17:45:12 GMT

Pl Check if you have marked 'show all values' in dimension tab, see this post -

Re: Filter straight table with expression results