Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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
Creator
Creator

Hi Paul, have You tried Conditional for these columns?

Can You send some example qvw in attach?

regards

Jacek

amit_saini
Master III
Master III

jonathandienst

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
Partner

Hi,

Probably best to fix all the NULLs from the script.

NULL handling in QlikView

paulm
Contributor III
Contributor III

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
Partner

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
Creator
Creator

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

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

Would there be any other way you would suggest?

paulm
Contributor III
Contributor III

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