topic Re: Tabular Format in Alert Wizard in QlikView- Possible? in App Development

Tabular Format in Alert Wizard in QlikView- Possible?

dmohanty — Thu, 09 Sep 2021 08:55:08 GMT

Hello Team,

We have certain messages inside a Alert Wizard in QlikView (Image below) - that is generating a message body in the Mailbox.

Email Body looks like this (have added Pipes as Delimiter)

Region | Sales | Profit

A | $10.5K | $200

B | $9.7K | $120

C | $14.1K | $380

Requirement:

Can we build/design/insert a Table in Alert Wizard, so the email body content should come in a Tabular Format instead of manual delimiters/Pipes? Can we also make Headers Bold or Colored?

(Like this below):

Region	Sales	Profit
A	$10.5K	$200
B	$9.7K	$120
C	$14.1K	$380

Regards!

Re: Tabular Format in Alert Wizard in QlikView- Possible?

marcus_sommer — Thu, 09 Sep 2021 12:53:21 GMT

You could try to imbed your data within a html-structure with an appropriate nested <table><tr><td>. For this create your table like they should be and export it as html. Now you have the needed structure and could replace the fixed values with your variable-values and/or any expressions.

Before use this content a it is within an alert to check if it's recognized from target as (valid) html. I'm not sure how the html looks like and if it needs some adjustments like <header><body> and so on and/or if you need to add/adjust any formattings within it. There are plenty of examples for simple html if your searched for it with google.

- Marcus