Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Applicable88
Creator III
Creator III

After If-Statement is fulfilled , a string and the fieldvalue as outcome

Hello,

how to add a string to your corresponding fieldvalue.

Example:

=if([DeliveryDate]>0, 'Delivered at [DeliveryDate'], 'Not yet delivered')

Seemingly the single quotes cannot recognized the Fieldname here. I tried with Chr() function, might used it wrong. 

Hope someone can provide the answer.

Best. 

1 Solution

Accepted Solutions
QFabian
Specialist II
Specialist II

Hi, are you doing this in script or expression?

moving one of the sinlge quotes, like this :

=if([DeliveryDate]>0, 'Delivered at ' & [DeliveryDate], 'Not yet delivered')

QFabian

View solution in original post

2 Replies
QFabian
Specialist II
Specialist II

Hi, are you doing this in script or expression?

moving one of the sinlge quotes, like this :

=if([DeliveryDate]>0, 'Delivered at ' & [DeliveryDate], 'Not yet delivered')

QFabian

View solution in original post

Applicable88
Creator III
Creator III
Author

Thanks @QFabian ,

it works and it was for a expression in a table.

Best.