topic Re: Re: Null Values Issue in QlikView

Null Values Issue

Fri, 11 Oct 2013 09:49:32 GMT

Hi Friends,

I am facing an issue with the null values.I need to show the From amount for FROM_Person---->TO_Person.

Please find the attached sample data.

Desired Output:

	BCD	DEF	MNO
ABC	10
CEF		30
XYZ			50

Re: Null Values Issue

datanibbler — Fri, 11 Oct 2013 09:54:42 GMT

Hi Roopesh,

you can try using the ISNUM() function (in an IF() clause with an alternative value) to get qlikView to load something when there is no value in the base file.

Re: Re: Null Values Issue

Fri, 11 Oct 2013 10:06:08 GMT

Thanks for the response Friedrich.

I am attaching my sample QVW.

I am not getting the output as desired.

Re: Null Values Issue

datanibbler — Fri, 11 Oct 2013 10:11:19 GMT

Hi,

kindly attach the base Excel file, too or put the required data in an Inline table so it works. I assume the issue is in the base file which you cannot change? - I usually talk to the people in charge of populating those files and tell them that empty cells are not good. However, there is surely a way to allow for that in QlikView.

Best regards,

DataNibbler

Re: Re: Null Values Issue

Fri, 11 Oct 2013 10:15:19 GMT

PFA excel.

Re: Null Values Issue

tresB — Fri, 11 Oct 2013 10:17:14 GMT

Is this what you need ? PFA

Re: Null Values Issue

v_iyyappan — Fri, 11 Oct 2013 10:19:12 GMT

Hi,

PFA,

Regards,

Re: Re: Null Values Issue

Fri, 11 Oct 2013 10:24:39 GMT

My Desired Output is:

Desired Output:

	BCD	DEF	MNO
ABC	10
CEF		30
XYZ			50

Re: Re: Null Values Issue

Fri, 11 Oct 2013 10:27:20 GMT

The dimensions must be FROM_Person & TO_Person.But the expression must be FROM_Person amount only.

Desired Output:

	BCD	DEF	MNO
ABC	10
CEF		30
XYZ			50

Re: Null Values Issue

Fri, 11 Oct 2013 11:21:33 GMT

Refer second sheet in excel file.

Final Output Required:

	BCD	DEF	MNO
ABC	10
CEF		30
XYZ			50

Re: Null Values Issue

m_bardun — Fri, 11 Oct 2013 11:37:24 GMT

See attached document for a solution.

Re: Re: Null Values Issue

Gysbert_Wassenaar — Fri, 11 Oct 2013 11:37:51 GMT

See attached qvw.