Data formating for alerts and dimensions selection

[Tenuki]

Hello,

I manage to create a simple alert to test my SMTP parameters and it worked.

Thus, I would to have my data in the right format, and Qlik send me a CSV file where each row look like this :

5515,1, 39 € ,2 €,"5,74%"

I think this "€" is "€" 

Is there a possibility to choose the format in the csv file ? Or have a excel file instead ?

Second question :

When I create my alert, I would like to add multiple dimension, but I didn't manage to do so.  

Is it possible ? 

Many thanks for your help.

[Chanty4u · Accepted solution]

Hi

May be try this 

Num(Amount,'#,##0 €')

Or

Num(Amount,'#,##0 [$€]')

Or in Load script  set below 

SET MoneyFormat='#,##0.00 €;-#,##0.00 €';

[avinashelite · Accepted solution]

Hi,

• If under 10 rows: The alert data appears directly in the email body.
• If over 10 rows: Qlik attaches a CSV file to the email containing all triggered rows.
• Important Note: Because Qlik exports these CSV files with Tab delimiters, you must open them properly in Excel. Open a blank Excel workbook, go to the Data tab, click Get Data (or From Text/CSV), and specify Tab as the delimiter so your columns line up perfectly. 

For the Excel part , check this , but its available only in Qlik cloud I think.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Design/OfficeC...

[Tenuki]

Many thanks @avinashelite, @Chanty4u