topic Re: Qlik Alerting - Drill to Dimension Customized Notification in Reporting Service & Alerting

Qlik Alerting - Drill to Dimension Customized Notification

yadavprachi02 — Wed, 29 Jan 2025 15:57:23 GMT

Hi All,

I am trying to send a customized notification to a group of users with Drill to Dimension feature.

We have 1 Dimension and 3 measures. What will be the code/dynamix text variable to differentiate these 3 measures and put it in a table format in HTML. The help page do provide syntax for one measure in case of drill to dimension feature but for multiple measures, I am not able to find any syntax.

Drill to Dimension with Single Measure

Can anyone please help me out here. I tried using {{qNum.0}}, {{qNum.1}}...so on but it doesn't work. In case of Deafult template, the table is showing up for all the measures across dimension. Need the logic for Customized notification

Re: Qlik Alerting - Drill to Dimension Customized Notification

Patricia_Silva — Tue, 17 May 2022 13:29:52 GMT

Hello @yadavprachi02, could you kindly please share a visual example of what you want to achieve? Thanks a lot!

Re: Qlik Alerting - Drill to Dimension Customized Notification

yadavprachi02 — Wed, 25 May 2022 08:05:19 GMT

Hi Patricia,

I want to send a table through alerts with one dimension and multiple measures. Please refer to the table example given below:

So if a user have access to two employees then he should be able to see data for those two employees in below format.

Employee ID (Dimension)	Leaves(1st Measure)	Attendance(2nd Measure)	Salary(3rd Measure)
1	10	70%	20000
2	5	30%	10000

Re: Qlik Alerting - Drill to Dimension Customized Notification

yadavprachi02 — Wed, 25 May 2022 12:28:03 GMT

Got the solution using below code.

<table
style="color:#494848; font-size:13px; line-height:1.8; table-layout:auto; width:100%;">
<tr style="background-color: #fff">
<td
style="padding-top:5px; padding-bottom:5px; padding-left:10px; padding-right:10px">
<strong>{{dimensions.0}}</strong></td>
<td
style="padding-top:5px; padding-bottom:5px; padding-left:10px; padding-right:10px">
<strong>{{measures.0}}</strong></td>
<td
style="padding-top:5px; padding-bottom:5px; padding-left:10px; padding-right:10px">
<strong>{{measures.1}}</strong></td>
<td
style="padding-top:5px; padding-bottom:5px; padding-left:10px; padding-right:10px">
<strong>{{measures.2}}</strong></td>
</tr>
{{#dimensionValues}}
<tr>
<td
style="padding-top:5px; padding-bottom:5px; padding-left:10px; padding-right:10px">
{{{0}}}</td>
<td
style="padding-top:5px; padding-bottom:5px; padding-left:10px; padding-right:10px">
{{1}}</td>
<td
style="padding-top:5px; padding-bottom:5px; padding-left:10px; padding-right:10px">
{{2}}</td>
<td
style="padding-top:5px; padding-bottom:5px; padding-left:10px; padding-right:10px">
{{3}}</td>
</tr>
{{/dimensionValues}}
</table>

Re: Qlik Alerting - Drill to Dimension Customized Notification

Pallavi_Singh — Wed, 25 May 2022 13:19:01 GMT

Thanks a lot Prachi.

This resolved my issue

Re: Qlik Alerting - Drill to Dimension Customized Notification

PratikSrivastsava — Thu, 26 May 2022 09:25:30 GMT

Nice Solution.

Thanks for Posting the solution.