topic Re: Supress when null in Pivot Table in QlikView

Supress when null in Pivot Table

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a pivot table with 4 expressions in it.

I want to suppress zero/null values just for 1 expression and not others ( a business requirement).

But when i am doing that from presentation tab and Checking "Suppress values when null" , this is getting applied to all the expressions and not just that particular one.

I have tried writing conditional expression but not of any help. Please Guide.

[Elaborated Situation: Actually i am calculating share expression for products (Volume of one product/Volume of all products), when i am selecting any product the expression is getting calculated for that but the rows corresponding to other products are 0 and the table is not reducing]

Re: Supress when null in Pivot Table

Anil_Babu_Samineni — Fri, 30 Sep 2016 16:38:27 GMT

Which expression you want to suppress

You might need to use expression like this

Len(Expression) > 0

Re: Supress when null in Pivot Table

vikasmahajan — Mon, 03 Oct 2016 06:52:06 GMT

Hi Shilpa

IF ( Len(Expression) > 0 , Expression) this should work.

Vikas

Re: Supress when null in Pivot Table

sushil353 — Mon, 03 Oct 2016 07:05:39 GMT

if possible share the sample application for better resolution of your query.

Re: Supress when null in Pivot Table

rupamjyotidas — Wed, 12 Oct 2016 15:33:03 GMT

When you have multiple expressions in a table , it won't be possible to suppress zero/null for just one of the equation. what you can do it replace the zero/null to something

IF ( Len(Expression) > 0 , Expression) will give a empty bucket for the values not present

IF ( Len(Expression) < 0 , 0,Expression) will give Zero values for the values not present

Re: Supress when null in Pivot Table

Thu, 13 Oct 2016 05:08:37 GMT

Thanks all,

It wasn't working this way. as i had share expressions !

Temporarily i made separate chart for some of the expressions.

Re: Supress when null in Pivot Table

rupamjyotidas — Thu, 13 Oct 2016 16:54:09 GMT

Please close the discussion