topic Getting error for $ expansion variable check in If block in QlikView

Getting error for $ expansion variable check in If block

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

Hi All,

I have variable vTotalCount which will be assigned through input box. I want to check if variable has value then set to variable value but if varibale doesnot hold value then it should be set to default value to 24.

=IF(len(TRIM(vTotalCount))>0 ,vTotalCount,24) - This expression working as expected.

But when I use $ expansion , I am getting an error as below-

=IF(len(TRIM($(vTotalCount)))>0 ,vTotalCount,0)

Can someone please help me in this?

Re: Getting error for $ expansion variable check in If block

sunny_talwar — Tue, 12 Jun 2018 11:59:53 GMT

If it is working without dollar sign expansion, why do you want to use dollar sign expansion?

Re: Getting error for $ expansion variable check in If block

Peter_Cammaert — Tue, 12 Jun 2018 12:40:05 GMT

That seems very logical to me.

Imagine that vTotalCount either contains an empty string or a string composed of whitespace characters.

Then

Trim(vTotalCount) will take an empty or whitespace string from the variable, remove all whitespace characters present and return a blank string in all cases.
However, in those same cases Trim($(vTotalCount)) will exapand to either Trim() or Trim( ) without any parameter whatsoever. Which is an illegal function call.

Sunny's question still stands. But if you really want to keep the $-sign expansion, then put the $(...)-expression between single quotes. Trim() only operates on strings anyway...

[Edit] Sorry, kept finding spelling errors...

Re: Getting error for $ expansion variable check in If block

ashishbhuyekar — Tue, 12 Jun 2018 12:53:51 GMT

Sunny - You are correct, as it is working without $ expansion why to unnecessary complicate. Thanks for replying.