topic Re: Data formating for alerts and dimensions selection in Reporting Service & Alerting

Data formating for alerts and dimensions selection

Tenuki — Fri, 15 May 2026 08:31:48 GMT

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 — Sun, 17 May 2026 12:13:39 GMT

May be try this

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

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

Or in Load script set below

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

avinashelite — Mon, 18 May 2026 07:39:47 GMT

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.

Tenuki — Mon, 18 May 2026 08:01:51 GMT