A

[#1]

Hi All,

Is it possible to add another field to dimension other than the existing values of the column in the dataset. For example, I have attached a sample qvw . Here I have filters on the left side likie region, lsm_type , store_format. Now let us pick one filter say lsm_type : When I select only one region(values = inland, westerncape) and I do not select any value in store_format , the values include all the combinations of store_format. I want to include another field in the dimension store_format called no field selected, selecting which will give me results which are aggregated at only LSM_type filter and does not include store_format.

Do you guys have suggestions to implement this??

If it is not clear, please let me know.

[Anonymous]

You can use the function: NullAsValue [Field Name];

This will replace the nulls in your field with a zero-length string, making it selectable.  You could also replace the nulls in your entire application with something else:

SET NullValue = 'N/A';

NullAsValue [Field Name];

NullAsNull *;

[#3]

I just want to do it for one list box. So, can I add this as an expression , if not where do we add the function

[#4]

I do not see the NullAsValue function, the only function which is shown under "Null" category is IsNull

[Anonymous]

I believe NullAsValue is script-side only.  Not sure if there is a way to accomplish what you want in the front-end.  Maybe somebody else has a tip?

[#6]

Hi,

Even on the edit script page, I tried to add this function but it does not recognise. Can you help?