topic Re: Coversion into Table in QlikView

Coversion into Table

Fri, 25 Oct 2013 12:04:50 GMT

Hi,

Can we send a field containing different columns in Table form in mail.

EX. i am sending field which is coming from script like concat(&&) as ABC. i want to send this field in tabular form in email. now its coming in list form. is there any other way to send this field in html table format or excel table format.

Regards,

Piyush Jain

Re: Coversion into Table

tresB — Fri, 25 Oct 2013 13:24:16 GMT

How would you like to present a table with data like:

FieldWithFieldNames

Field1

Field2

Field3

Re: Coversion into Table

javier_florian — Fri, 25 Oct 2013 13:26:28 GMT

You can export data in csv file, this work with excel.

Re: Coversion into Table

Fri, 25 Oct 2013 13:27:20 GMT

Hi tresesco,

If i have field abc formed by conacat(,,), then i want to show it in tabular form like a b c as column in a table format.

Regards,

Piyush Jain

Re: Coversion into Table

tresB — Fri, 25 Oct 2013 13:34:03 GMT

You can take the fields a, b, c directly instead of taking ABC (the concatenated one), right? May be I am missing something, can you explain with a sample data?

Re: Coversion into Table

Fri, 25 Oct 2013 14:38:18 GMT

Hi,

As discussed above i am sending field 'abc' formed in script like concat(,,) in mail through alert option.

the field in mail is coming like..

abc,xyx,xyz
abc,xyx,xyz

abc,xyx,xyz

it is coming in list form. i want it to come in tabular form as in attachment.

Regards,

Piyush Jain