topic Re: IF statement to use populated field in QlikView

IF statement to use populated field

khaycock — Wed, 25 Nov 2020 16:16:04 GMT

I have two reports of data but I want to generate a statement that will only show data from a field if it is populated, and if it isn't populated show the other field.

I know this is a generic IF statement but can't figure out how to word the IF statement for a populated field rather than a specific selection.

Something like:

IF([Mike Risk Factor]=(no idea what to put here), [Mike Risk Factor], [Risk Factor])

Re: IF statement to use populated field

giovanneb — Mon, 03 Sep 2018 14:09:03 GMT

Try this,

IF(LEN(TRIM([Mike Risk Factor]))>0, [Mike Risk Factor], [Risk Factor])

Re: IF statement to use populated field

atoz1158 — Mon, 03 Sep 2018 14:13:09 GMT

You may also want to cater for the case of the field being NULL by using

isnull([Mike Risk Factor])

Re: IF statement to use populated field

BalaBhaskar_Qlik — Mon, 03 Sep 2018 16:14:50 GMT

Try this:

IF([Mike Risk Factor]=' ', [Mike Risk Factor], [Risk Factor]) as Factor

Re: IF statement to use populated field

atoz1158 — Tue, 04 Sep 2018 08:47:20 GMT

Try this covering both an empty field and a null field

IF(TRIM([Mike Risk Factor])='' OR ISNULL([Mike Risk Factor]), [Risk Factor], [Mike Risk Factor])

Re: IF statement to use populated field

giovanneb — Tue, 04 Sep 2018 11:22:27 GMT

My recommendation would already treat the field by removing the nulls with TRIM and it would check if the field size is greater than 0 with LEN thus perfectly servicing the request.

Reguards