topic Re: If dimension is null then show other field in QlikView

If dimension is null then show other field

neena123 — Sat, 16 Nov 2024 20:12:19 GMT

Hello,

I have a straight table that has address information on it.

I would like the dimension to say If(Address1) is null then display TAddress1 but it isn't working. This is my exact dimension

=IF(([Address 1]=null()),TAddress1)

What am I doing wrong?

Re: If dimension is null then show other field

Vegar — Fri, 23 Aug 2019 21:14:50 GMT

=IF(isnull([Address 1]),TAddress1)

See https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/NULLFunctions/IsNull.htm

Re: If dimension is null then show other field

neena123 — Fri, 23 Aug 2019 21:16:01 GMT

Yes, I should of put that down but I did try that already and it didn't work. Thanks Though!!

Re: If dimension is null then show other field

Vegar — Fri, 23 Aug 2019 21:25:15 GMT

Could it be that it is not an null value?

Try this:

IF(len([Address 1])=0,TAddress1)

Re: If dimension is null then show other field

neena123 — Fri, 23 Aug 2019 21:30:29 GMT

That didn't work either. But what do you mean that it is not a real null value?

Re: If dimension is null then show other field

Vegar — Fri, 23 Aug 2019 21:33:37 GMT

It could be just an empty string, ''.

Re: If dimension is null then show other field

neena123 — Fri, 23 Aug 2019 21:44:08 GMT

Ok. I think this works for me. =IF(len([Address 1]=null()),TAddress1) Thanks for the help!

Re: If dimension is null then show other field

Vegar — Fri, 23 Aug 2019 21:53:37 GMT

That's great!

If so, please mark this question as solved. That will guide other users right in the future.

Re: If dimension is null then show other field

Timothy958 — Sat, 24 Aug 2019 12:06:43 GMT

As above, the only change I would make is not to use the isnull function which is a bit sketchy at times!

if(len(Product_DESCR)<1,Code,Product_DESCR) as data

Re: If dimension is null then show other field

Murugesan — Mon, 24 Jun 2024 06:43:08 GMT

Hello,

If(

IsNull(industry)or Len(industry) <1,

industry,

Industry_New)

The given solution is working fine, but it shows all the values are possible value from the field(ex. industry) in the header search box.
In the below img, the industry is holding companies but in the search box it shows all the value

Is there any way to control this