topic How to avoid executing the code is the field in the code are blank in QlikView

How to avoid executing the code is the field in the code are blank

Wed, 12 Jan 2011 08:03:18 GMT

Below is the code I am using in the dimension field for displaying the something like A1-09, where A1 is the month and 09 is the year as per our understanding. I don't want the below code to be executed if FINISHPERIOD and FINISH_YEAR are blank. Please let me know how to do this.

=FINISHPERIOD&'-'&right(FINISH_YEAR,2)

See the below image, I think I am getting - (because of this &'-'& in the above code)when both the fields are blank.

How to avoid executing the code is the field in the code are blank

jonathandienst — Wed, 12 Jan 2011 08:21:21 GMT

This should do the trick:

=If(Len(FINISHPERIOD) > 0 And Len(FINISH_YEAR) > 0, FINISHPERIOD & '-' & right(FINISH_YEAR, 2))

Jonathan

How to avoid executing the code is the field in the code are blank

Wed, 12 Jan 2011 08:26:30 GMT


Jonathan Dienst wrote:
This should do the trick:
=If(Len(FINISHPERIOD) > 0 And Len(FINISH_YEAR) > 0, FINISHPERIOD & '-' & right(FINISH_YEAR, 2))<div></div>

Just now I did exactly the same thing and seeing your code after that. Many thanks for your support.

Cheers

How to avoid executing the code is the field in the code are blank

Wed, 12 Jan 2011 09:25:07 GMT


Attitude wrote:
<pre>
Jonathan Dienst wrote:
This should do the trick:
=If(Len(FINISHPERIOD) > 0 And Len(FINISH_YEAR) > 0, FINISHPERIOD & '-' & right(FINISH_YEAR, 2))<div></div>

Just now I did exactly the same thing and seeing your code after that. Many thanks for your support.

Cheers

Hi
To be on the safe side, you might also use trim:

len

(trim(FINISHPERIOD))>0

Rgds
Jonas

Consultant @ Optivasys | http://www.optivasys.se

How to avoid executing the code is the field in the code are blank

Wed, 12 Jan 2011 10:10:24 GMT

Thanks Jonas!

You are right too...