topic Re: Valuelist Null Column in QlikView

Valuelist Null Column

paulm — Wed, 01 Apr 2015 17:22:31 GMT

Hi,

I have a table made up of with a valuelist dimension, but not every set of expressions are needed for each value in the valuelist. Currently when displaying, I am getting a '-' in the columns that are empty.

Any way of removing this?

Thanks
Paul

Re: Valuelist Null Column

Jacek — Thu, 02 Apr 2015 12:04:20 GMT

Hi Paul, have You tried Conditional for these columns?

Can You send some example qvw in attach?

regards

Jacek

Re: Valuelist Null Column

amit_saini — Thu, 02 Apr 2015 12:06:58 GMT

Paul,

Check:

https://community.qlik.com/message/678024#678024

https://community.qlik.com/message/436820#436820

Thanks,
AS

Re: Valuelist Null Column

jonathandienst — Thu, 02 Apr 2015 12:07:36 GMT

On the Presentations tab, enter a space in the Null Symbol box to hide the -

HTH

Jonathan

Re: Valuelist Null Column

Gabriel — Thu, 02 Apr 2015 12:42:57 GMT

Hi,

Probably best to fix all the NULLs from the script.

NULL handling in QlikView

Re: Valuelist Null Column

paulm — Thu, 02 Apr 2015 12:49:31 GMT

HI Guys,

Please see attached my example document. I would like to remove the column Walk under expression 3, but need to keep walk under the other 2.

Thanks
Paul

Re: Valuelist Null Column

Gabriel — Thu, 02 Apr 2015 13:03:29 GMT

Hi,

In the script catch all the NULLs

MAPPING LOAD

NULL(),

'Unknown'

Autogenerate 1;

And before FACT table say

MAP "*" USING Map_NULLs;

UNMAP "%*"; //% will be fields you which to exclude from current selection box

Re: Valuelist Null Column

Jacek — Thu, 02 Apr 2015 13:40:17 GMT

I am afraid, you cannot hide this column. Pivot table has data in other cells, related with this null cell.

Re: Valuelist Null Column

paulm — Fri, 03 Apr 2015 08:21:28 GMT

Thanks Jacek, didn't think it would be possible.

Would there be any other way you would suggest?

Re: Valuelist Null Column

paulm — Fri, 03 Apr 2015 08:22:34 GMT

HI,

Thank for the reply, but the nulls are coming from the valuelist, not the script so I cannot catch them within the back end script

Thanks

Paul

Re: Valuelist Null Column

Fri, 08 May 2015 21:23:35 GMT

Hey Paul,

Were you able to figure out a way to resolve this. I've been struggling with the same thing! I've been trying to implement conditional expressions to get around it and that doesnt work either.