topic Re: Not able to supress in QlikView

Not able to supress

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

We are using pivot table actually there is no null in the dimensions Market,Location and Date fields but when i created an pivot chart it is showing null and i need to remove the null column.

Below is the image for reference.

Thanks..

Re: Not able to supress

Chanty4u — Wed, 16 Nov 2016 10:28:38 GMT

Hi,

supress the row when the value of column is null?

In this case you put in the dimension the expresion:

if(IsNull(expresion, Null(), Dimension)

and select the option to supress if is null

Re: Not able to supress

ElizaF — Wed, 16 Nov 2016 10:28:39 GMT

Check the the option "Suppress When Value is Null" from Dimensions tabs of the chart.

See below the image:

Re: Not able to supress

nareshthavidishetty — Wed, 16 Nov 2016 10:31:47 GMT

Hi,

I don't want to suppress null values as i need markets which don't have sales as well.

Thanks..

Re: Not able to supress

gireesh1216 — Wed, 16 Nov 2016 10:44:33 GMT

Hey Naresh,

Each and every dimension you need to check "Suppress When Value is Null".Then only it will work

Re: Not able to supress

jyothish8807 — Wed, 16 Nov 2016 11:08:43 GMT

Hi Naresh,

Select supress null value only for Dimension "Date" and give it a try.

Also fro presentation tab check " supress zero value".

Br,

Re: Not able to supress

chhavi376 — Wed, 16 Nov 2016 11:09:00 GMT

Hi Naresh,

You can "Suppress When Value is Null" only in 'Month' dimension.

Also, if you could please upload the QV for a better understanding.

Thanks,

Chhavi