topic Re: alt fun? in QlikView

alt fun?

Anonymous — Fri, 23 Jan 2015 12:59:58 GMT

alt(01/01/2015,01-01-2015,01-01/2015) it returns correct date as for my understanding

but i want know what is the use of alt function when u go for this

give me small example

Null values can be removed using alt fun?

Re: alt fun?

alexandros17 — Fri, 23 Jan 2015 13:03:59 GMT

The alt function returns the first of the parameters that has a valid number representation. (as dates do). If no such match is found, the last parameter will be returned

Re: alt fun?

Anonymous — Fri, 23 Jan 2015 13:07:50 GMT

is it possible to remove null values with alt function

Re: alt fun?

kuba_michalik — Fri, 23 Jan 2015 13:10:40 GMT

Only if you are testing numeric values for being non-null. It won't work for text.

You can use IsNull() to test for nulls and combine with If() to remove them if needed.

Re: alt fun?

alexandros17 — Fri, 23 Jan 2015 13:12:57 GMT

I think it is not the better way to remove null values ...

If you want

to remove from the script (in a load or select) put a where condition (Ex. Where not IsNull(myField)),
if the field is a dimension, there is a check box to delte null values in the tab dimension.

Let me know