Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.
Thanks for the response Friedrich.
I am attaching my sample QVW.
I am not getting the output as desired.
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
PFA excel.
Is this what you need ? PFA
Hi,
PFA,
Regards,
My Desired Output is:
Desired Output:
BCD | DEF | MNO | |
ABC | 10 | ||
CEF | 30 | ||
XYZ | 50 |
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 |
Refer second sheet in excel file.
Final Output Required:
BCD | DEF | MNO | |
ABC | 10 | ||
CEF | 30 | ||
XYZ | 50 |