topic Give some name for Null Data in QlikView

Give some name for Null Data

Thu, 19 Aug 2010 07:44:26 GMT

Hi,

I am designing a graph for number of employees for each city. There is no data for the city field for some employees so it us seen as blank in bar chart as well as list box. I need to replace teh Null Vlaue with 'No Data'. How to do this?

Give some name for Null Data

Thu, 19 Aug 2010 07:50:47 GMT

Hi,

You can write if condition for that like: if len(EmployeeName>0,EmployeeName,'Others') as EmployeeName.

Regards,

Ravi

Give some name for Null Data

Thu, 19 Aug 2010 07:55:21 GMT

Try this expression

If(isnull(city) or len(trim(city))=0,'No Data',City) as city

Give some name for Null Data

Thu, 19 Aug 2010 09:22:15 GMT

Hi,

Thanks, It worked when I gave the formula at Script level. But how to do at the report level? If it part of a multibox or a list box or a chart.

Nanda.

Give some name for Null Data

johnw — Fri, 20 Aug 2010 00:54:15 GMT

I recommend doing it in the script for performance. But if you really want to do it in an object, the syntax is the same. For instance, create a list box, select <expression> instead of the field, and enter the expression that was working in your script (without the "as city" part).