topic Issue with Chr and using as in App Development

Issue with Chr and using as

hermanitor — Wed, 21 Jun 2023 10:58:08 GMT

Hi,

I have a dimensions in a table that I am using to send out a message to some email recipients.

Data:
Load
'String' as [Dear Colleague(s) & Chr(44) & Chr(10) Please]

Now whatever I do in the square brackets, it still does not format the as part in the message as I require.
I have tried to do this as a variable and create a long string here and then use the variable in the as instead of creating a long string there.
Either way, neither method appears to be working for me.
I am not going to send the very long string that I am required to build!

Any ideas on how to solve?
Any further questions?

Any assistance appreciated. (he said banging his head against the wall!)

Re: Issue with Chr and using as

Chirantha — Wed, 21 Jun 2023 11:21:37 GMT

Please try this (without square brackets) and see if it helps

Data:
Load
'String' & Chr(44) & Chr(10) & 'Please' as Message;

Re: Issue with Chr and using as

Aditya_Chitale — Wed, 21 Jun 2023 11:43:25 GMT

You can directly use ' , ' instead of chr(44) & ' - ' instead of chr (10) in field name as it is going to remain constant.

Regards,

Aditya

Re: Issue with Chr and using as

hermanitor — Wed, 21 Jun 2023 12:17:58 GMT

Hi Chirantha,
The issue is not the creation of the dimension. This part is fine.
My issue is with the part of 'as Message' This is the part that I want to change/maniupulate...

Re: Issue with Chr and using as

rwunderlich — Wed, 21 Jun 2023 15:23:17 GMT

You can do it like this:

Let fname = 'Dear Colleague(s)' & Chr(44) & Chr(10) & 'Please';
Data:
Load
'String' as [$(fname)]
AutoGenerate 1;

I don't think there is any way to dynamically calculate the fieldname within the Load statement. The fieldname must be a constant.

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

Re: Issue with Chr and using as

hermanitor — Fri, 23 Jun 2023 09:57:35 GMT

Hi All.
Thanks for the responses concerning this.
The use case for this was to send an email message, which we are doing via the the SMTP method.
Instead of embedding the information in the message I was trying to add it to the link via an 'as methodology'.
In the end I have just embedded the string in the email body message.
Not what I wanted to do, but it solves the solution...!
However I did have some fun with trying to solve this using a number of results.
Thanks for any support provided here. Am sure I will have a play with the strings in the future
Steve