Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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