topic formatting in email in QlikView

formatting in email

Thu, 10 Oct 2013 13:45:06 GMT

Hi,

In alert option i am sending a field in mail on reload. the field is nothing but concatination of different fields like concat(name, & date, &product, & product id) as field. in mail that particular field is coming in list form. i want all the values should come in different row.

Ex- name, date, year, product,product id,name,date

year,product,product id, name,date,product.... it is comming likewise.

i want it like

name,date,product,product id

note: all above field contain some numerical values.

Re: formatting in email

francoiscave — Thu, 10 Oct 2013 13:59:53 GMT

Hi Piyush,

It's something like this:

&chr(10)&

Concat(DISTINCT{<Field_Conditionf={'value'}>}name&' , '&Date&' , '&product,','&chr(10))

&chr(10)& ''&

François

Re: formatting in email

Fri, 11 Oct 2013 09:28:23 GMT

Hi Cave,

I am trying chr(9) and the field is coming half in list form and half in tabular form.

name,date,product, product id,name,date,

product,product id,

name,date,product,product id,

like wise. half of the mail is formatted and half is not formatted.