topic Re: Problem with Code filter in QlikView

Problem with Code filter

Luke_Killer_IT — Tue, 08 Jun 2021 09:49:26 GMT

Hello

I have a problem with data filtering. I want text instead of blank fields in one column

It's My code if(Termine= null(),text('KaineAB'))

Or — Tue, 08 Jun 2021 10:58:49 GMT

Try using the isnull() function instead of = null().

Luke_Killer_IT — Tue, 08 Jun 2021 11:04:38 GMT

I used isnull () and it didn't help

NitinK7 — Tue, 08 Jun 2021 13:16:08 GMT

use

if(Len(Termine)= 0,text('KaineAB'), Termine)

MayilVahanan — Wed, 09 Jun 2021 01:55:26 GMT

Try like below

if(Len(Trim(Termine))= 0,'KaineAB', Termine)

Luke_Killer_IT — Wed, 09 Jun 2021 05:39:13 GMT

I used your code but it still did not work, I will attach a screenshot, maybe it will be easier.

Only the red box is to have 'Kaine AB'.

MayilVahanan — Wed, 09 Jun 2021 06:59:55 GMT

Hi,

try like below

if(Isnum(Termine), Termine, 'KaineAB')

Or, send the sample file to verify