Launch email From Text Object

[jmonroe918]

I have a text object where I would like to launch MS Outlook with a particular email address and standard subject text. From there requestor will type the content of the email.

Thanks for the help.

Jeff

[iktrayanov]

After this you need to parse the result something like this

=subfield(Variable2, '=' ,5)&'@MyDomain.com'

[#3]

Hi Ivan,

Awesome!! Thank you so much. It worked out well. In case of any query in QlikView I would contact you.

Wish you a great time ahead. Bye for now.

Regards,

Arun.

[#4]

Hi Ivan,

I am having data extracted from SQL table and I am matching it with an inline table to get a field.

But the null data is not coming in the chart. Please help me on this.

Below is my inline table

Start:

ADD LOAD * Inline [_HW_Code, _SW, _SW Name, _BUSINESS, _Domain, _SW Domain Desc, _L1, _L2

BB, RR, Services, Support, <NULL>, <NULL>, Services, Services
 

<NULL>, <NULL>, Others, Others, Others, Others, Others, Others

] ; 

Below is my Dimension expression in sparkline chart

=if(HW=_HW_Code,if(Match([_L1],'Segment','Services','Software','Engineering','Technology','Support')>0,[_L1],'Others')
,If(IsNull(_HW_Code),'Others'))

Note:

'Supress when value is null' is NOT ticked, nor is 'Supress zero-values' or 'Supress Missing'.

[iktrayanov]

When loading your data from SQL try using NullAsValue statement before the load(see QlikView help for NullAsValue and NullAsNull)

[iktrayanov]

Also before your inline load add this

SET NULLINTERPRET=<NULL>;

Regards,

Ivan

[#7]

Hi Ivan,

Thank you very much. It worked.

Regards,

Arun.

[iktrayanov]

Arun,

You may want to start a new tread if you have a question unrelated to this one.

Regards,

Ivan

[Josh_Good]

You can use the Open URL action and set the URL using the mailto keyword.

For example you could write the following the URL to send an email to Obama@whiltehouse.gov with the subject Congrats Obama.

='mailto:obama@whitehouse.gov?subject=Congrats%20Obama'

[#10]

Hi Ivan,

Thank you for your suggestion. I tried several times, but I have been denied logging a new thread. But I am able to reply to the existing threads, Strange!

Regards,

Arun.