Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Highlighted
egoss_cynosure_
New Contributor II

Qlik Sense Info Bubble

Hello,

I'm working in Qlik Sense GeoAnaltyics and trying to create an info bubble that adds two amounts to display the total. I separated the two sections...

   <tr>

<td style="text-align:Left;"><B>Order Amt</B>

' &Sum({$<[Order - Order Type] -= {'MAR STANDING ORDER'}, [Filter - Date Context]={'Booked'}>}[Amount - Ordered USD]) &'         

PLUS HERE

         '&Sum({$<[Order - Order Type] = {'MAR STANDING ORDER'}, [Filter - Date Context]={'Shipped'}>}[Amount - Shipped/Fulfilled USD])) &'</td> 

   </tr>

Does anyone know how I can use a plus operator to do this. I've tried it a bunch of different ways with no luck.

Thanks in advance!

Ed

2 Replies
Partner
Partner

Re: Qlik Sense Info Bubble

hi

try some thing like

=' <tr><td style="text-align:Left;"><B>Order Amt</B>' &

Sum({$<[Order - Order Type] -= {'MAR STANDING ORDER'}, [Filter - Date Context]={'Booked'}>}[Amount - Ordered USD]) +Sum({$<[Order - Order Type] = {'MAR STANDING ORDER'}, [Filter - Date Context]={'Shipped'}>}[Amount - Shipped/Fulfilled USD])) &'</td> </tr>'

Highlighted
egoss_cynosure_
New Contributor II

Re: Qlik Sense Info Bubble

Hi Liron,

Thanks for the response! That didn't work, but I used javascript in the info bubble and was able to get it working.

   <p id="calc1"></p>

     <script>

  var x = ' &Sum({$<[Filter - Date Context]={'Booked'}, [Order - Item Type Code]-={'INCLUDED'}>}[Units - Ordered])  &';

  document.getElementById("calc1").innerHTML = "Qty Ordered - " + x;

</script>