topic Re: A in QlikView

A

Mon, 18 Jun 2012 14:02:34 GMT

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.

Re: A

Anonymous — Mon, 18 Jun 2012 14:34:01 GMT

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 *;

Re: A

Mon, 18 Jun 2012 16:02:53 GMT

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

Re: A

Mon, 18 Jun 2012 16:55:01 GMT

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

Re: A

Anonymous — Mon, 18 Jun 2012 17:05:43 GMT

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?

Re: A

Mon, 18 Jun 2012 17:24:12 GMT

Hi,

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