topic Wildmatch to blank values in QlikView

Wildmatch to blank values

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

Hi All,

I am trying to wildmatch to a set value which is working but i have a new requirement to also wildmatch to Blanks in the excel source.

I am trying the following but for the [Invoice no.] with blank, the data are not importing.

WHERE not IsNull([Invoice no.]) and wildmatch ([Account Code],'*61100000000*','*NULL*') ;

Please can you help me to achieve the script for matching to the number '61100000000' and also blanks in [Account Code]

Thank you in advance

Daniel

sunny_talwar — Tue, 12 Nov 2019 13:20:09 GMT

May be try this

WHERE not IsNull([Invoice no.]) and (wildmatch ([Account Code],'*61100000000*') or Len(Trim([Account Code])) = 0);

davyqliks — Tue, 12 Nov 2019 13:21:12 GMT

Hey,

Thanks so much Sunny, i will try this now and feedback.

Your help is really appreciated.

Daniel

davyqliks — Tue, 12 Nov 2019 15:25:09 GMT

This worked perfectly, Thank you so much Sunny,

Daniel