Select blank in drop down list qlikview

[ashishpalkar]

Hi There

I have created chart table and showing multiple column data. Users seeing blank records as '-'.

I want to allow users to select '-' when they click on drop down of selected column.

Any suggestions?

Thanks in advance,

[ashishpalkar]

Thanks Peter,

Is there any way we can set Null as '-' globally instead of setting on each script tab?

below we are setting Null at only one script, what if there are multiple tabs?

NullAsValue A,B;

Set NullValue = 'NULL';

LOAD A,B from x.csv;

[Peter_Cammaert]

Why do you set it on each script tab?

Script tabs aren't separate scripts (unless you package the code on each tab in separate SUBs) and they are executed sequentially, starting from the leftmost tab.

If you set the NULLASVALUE variable on the first tab (before the first LOAD on that tab), it will be applied for all successive LOADS on all other tabs, until you provide a new SET NULLASVALUE statement or you reset the NULLASNULL state for some fields.

[Peter_Cammaert]

If you don't know what I mean, export your script to a script file using File->Export to Script File... in the script editor. Open the script file (just text) in a text editor (like Notepad) and you'll see how the code on each tab is ordered and tagged.

Peter

PS If you think any other response in this prolonged discussion is useful to you, use Actions->Helpful in the lower left corner to mark the response as such.