Qlik Alerting - Drill to Dimension Customized Notification

[yadavprachi02]

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

[Patricia_Silva]

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

[yadavprachi02]

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

[yadavprachi02 · Accepted solution]

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>

[Pallavi_Singh]

Thanks a lot Prachi. 

This resolved my issue 

[PratikSrivastsava]

Nice Solution.

Thanks for Posting the solution.