Null Values Issue

[#1]

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

[datanibbler]

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.

[#3]

Thanks for the response Friedrich.

I am attaching my sample QVW.

I am not getting the output as desired.

[datanibbler]

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

[#5]

PFA excel.

[tresesco]

Is this what you need ? PFA

[v_iyyappan]

Hi,

PFA,

Regards,

[#8]

My Desired Output is:

Desired Output:

	BCD	DEF	MNO
ABC	10
CEF		30
XYZ			50

[#9]

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

[#10]

Refer second sheet in excel file.

Final Output Required:

	BCD	DEF	MNO
ABC	10
CEF		30
XYZ			50