topic How to make Null Values Selectables in QlikView

How to make Null Values Selectables

Fri, 13 Apr 2012 16:45:46 GMT

Hi All!!

My question its Simple.

When some report have some null values inside because, for instance, lets suppose that we have 2 tables and not all values from table A have one corresponding value on table B.

If a make an analysis with a Table B value, a null value will appear.

So, theres any way to make this null value selectable? The idea its to select all regs like:

With A Value 300 regs

With B Value 100 regs

With - Value 50 Regs

If you click on A, you can see the 300 datas. but you cannot click on "-" value.

Theres any way to make those 50 regs selectables??

Thanks for All!

Germán.

How to make Null Values Selectables

CELAMBARASAN — Fri, 13 Apr 2012 17:15:47 GMT

Hi,

Before the Loading the table use NullAsValue like below

NullAsValue regs; //regs is fieldName of the regs(you mentioned All regs)

Celambarasan

How to make Null Values Selectables

Fri, 13 Apr 2012 18:11:13 GMT

Thanks for the answer but i think its not correct because the nulls values are due to luck of datas into table B.

So, if i want to make an analysis of an table B dimention, all of the A table values that are not present on B table will appear in NULL into the report.

Thanks anyway.

How to make Null Values Selectables

rajni_batra — Mon, 16 Apr 2012 06:59:36 GMT

hello you can use

If(IsNull(Field),'Null Value',Field) AS Field.

hope it help

How to make Null Values Selectables

Thu, 19 Apr 2012 15:20:44 GMT

Thanks Rajni but this doesnt solve the non existing relationships thats provoque the null values.

Regards!

How to make Null Values Selectables

Thu, 19 Apr 2012 15:29:23 GMT

Try using If(IsNull(Field),'Null Value',Field) in the actual development like in a list box. It won't work in the script unless the table is joined and then you put it in a resident load of the combined tables

Re: How to make Null Values Selectables

Mon, 04 Nov 2013 18:03:21 GMT

Hello,

I made NULLs selectable in a chart Dimension by using the formula =if(IsNull(Field),'Nothing') and then selecting 'Suppress When Value Is Null'. This made the Nulls not Null and everything else NULL.