Qlik Community

Ask a Question

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
egoss_cynosure_
Contributor II
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
lironbaram
Partner
Partner

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>'

egoss_cynosure_
Contributor II
Contributor II
Author

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>