Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a function in Qlickview with will return the first non null value.
I am trying to do away with having to use multiple nested if statements.
Hello Alan,
Depending on how is your data base sorted, you have two functions to get a non null value. One is
but I prefer to useIf(Not IsNull(Field), Field)
Is that what you are looking for?If(Len(Field) > 0, Field)
The way to avoid null in your situation is to put distinct like this: firstsortedvalue( distinct ...
In my case working perfectly, hope it will help.