Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Luke_Killer_IT
Creator
Creator

Problem with Code filter

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'))

1 Solution

Accepted Solutions
MayilVahanan

Hi, 

try like below

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

Or, send the sample file to verify

Thanks & Regards,
Mayil Vahanan R

View solution in original post

6 Replies
Or
Master III
Master III

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

Luke_Killer_IT
Creator
Creator
Author

I used isnull () and it didn't help

NitinK7
Specialist
Specialist

use

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

MayilVahanan

Hi @Luke_Killer_IT 

Try like below

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

Thanks & Regards,
Mayil Vahanan R
Luke_Killer_IT
Creator
Creator
Author

 

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

Luke_Killer_IT_1-1623217138920.png

 

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

MayilVahanan

Hi, 

try like below

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

Or, send the sample file to verify

Thanks & Regards,
Mayil Vahanan R