Valuelist Null Column

[paulm]

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

[Jacek]

Hi Paul, have You tried Conditional for these columns?

Can You send some example qvw in attach?

regards

Jacek

[amit_saini]

Paul,

Check:

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

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

Thanks,
AS

[jonathandienst]

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

HTH

Jonathan

[Gabriel]

Hi,

Probably best to fix all the NULLs from the script.

NULL handling in QlikView

[paulm]

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

[Gabriel]

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

[Jacek]

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

[paulm]

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

Would there be any other way you would suggest?

[paulm]

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