topic Hide zero value in QlikView

Hide zero value

Thu, 16 May 2013 09:01:55 GMT

Hello

I have a pivot table with a sum field, and i want to hide the line if value in this field "Generalkost" is 0. How is this poible?

//Gunnar Schie\\

Re: Hide zero value

Thu, 16 May 2013 09:03:42 GMT

properties--> dimension--> select field--> then check supress null value

Re: Hide zero value

Thu, 16 May 2013 09:08:08 GMT

try this

if(Generalkost<>0,Generalkost)

Re: Hide zero value

Thu, 16 May 2013 09:13:53 GMT

Where can i write?

Re: Hide zero value

Thu, 16 May 2013 09:16:15 GMT

I tryed the "check supress null value in dmension"

and in presentation tab try to "supress zero values" in presentation tab, but nothing happend.

I send the QvW file, look at the tab Generalkostnader

Gunnar

Re: Hide zero value

kumarnatarajan — Thu, 16 May 2013 09:17:59 GMT

Hi,

Go to properties tab then check the "Suppress Zero Value" this very simple one.

else

put condition your expression level

Re: Hide zero value

kumarnatarajan — Thu, 16 May 2013 09:18:59 GMT

Hi,

share your expression syntex. can i help you

Re: Hide zero value

kumarnatarajan — Thu, 16 May 2013 09:32:43 GMT

Hi,

Nm field use to dimention. find the attached file

Re: Hide zero value

Thu, 16 May 2013 10:29:57 GMT

Yes i works, but i want to show prNr and PrName in pivot table, like:

162 - Vedlikehold grøntarbeider - serie_ - serie_2 ..........................

How to do this`

Gunnar

Re: Hide zero value

kumarnatarajan — Thu, 16 May 2013 10:34:40 GMT

Hi,

Go to Presentation tab then check the "Always Fully Expandad"

Re: Hide zero value

Thu, 16 May 2013 11:26:45 GMT

Is it possible to get values from a expression field in pivot table, in to a text or label object?

I want to show in textbox or label: Kredit til K-6799 & sum of colomn(7)(Generalkost)