Qn in expression

[#1]

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

[Oleg_Troyansky]

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

[#3]

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

[#4]

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

[#5]

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

[Digvijay_Singh]

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

Re: Filter straight table with expression results