Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
paulm
Contributor III
Contributor III

Valuelist Null Column

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

10 Replies
Jacek
Educator-Ambassador
Educator-Ambassador

Hi Paul, have You tried Conditional for these columns?

Can You send some example qvw in attach?

regards

Jacek

jonathandienst
Partner - Champion III
Partner - Champion III

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

Probably best to fix all the NULLs from the script.

NULL handling in QlikView

paulm
Contributor III
Contributor III
Author

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
Partner - Specialist III
Partner - Specialist III

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
Educator-Ambassador
Educator-Ambassador

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

pivot.png

paulm
Contributor III
Contributor III
Author

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

Would there be any other way you would suggest?

paulm
Contributor III
Contributor III
Author

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