Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Xolink1389
Creator
Creator

SUM values from a google sheet in a calculated dimension

Context:

i create dimension for a table using this expressions:

Xolink1389_1-1698779102888.png

Xolink1389_0-1698779042074.png

in order to make calculations on the dimensions i used this expression:

(sum({<Concepto={'CLIENTES','ANTICIPOS A INTERCOMPAÑIAS'},ID_Clase=-{'WE'}-{'WA'}-{'WI'}-{'KA'},MONEDA,NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR)
+
sum({<Concepto={'OTROS GASTOS POR AMORTIZAR','ANTICIPOS A PROVEEDORES','FUNCIONARIOS Y EMPLEADOS'},MONEDA,ID_Clase=-{'WE','WA','WI'},CME=-{'F'},FECHA_COMPEN={">$(=(Max(NUMMES_C)))  <=$(=NUM(Today()+Year(today()+10)))"},NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2)))  <=$(=Max(NUMMES_C))"}>} ImporteDMBTR)
+
sum({<Concepto={'ALMACEN DE REFACCIONES','EFECTIVO E INVERSIONES'},ID_Clase,MONEDA,NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR)
+
sum({<Cuenta={"=(Mid(Cuenta,1,4)=1288)"},ID_Clase,MONEDA,NUMMES={">=$(=(Max(NUMMES)-$(vMinFecha2))) <=$(=Max(NUMMES_C))"}>} ImporteDMBTR))/1000

 

calculations are fine, the problem come when i try to add or sum new values:

this is the google sheet i use:

Xolink1389_2-1698779713682.png

in order to sum i use this expression, i add it to the main expression.

+
IF(MID(Cuenta,1,4)>=1101 AND MID(Cuenta,1,4)<=1101,SUM({<FechaBG2={'$(=MesC&AñoC)'}, ConceptoBG2 = {'CAJA'},SociedadBG2={'$(=Sociedad)'}>} ImporteBG2))



Xolink1389_3-1698780148479.png

and all values dissaper

Xolink1389_4-1698780198069.png

its there another or make a better expression to plus into my expression?

 

Labels (3)
1 Reply
Xolink1389
Creator
Creator
Author

im pretty sure that the expression work, since i used in another sheet from google, i tried diferent ways, and im guessing that the problem on the expression is this

Xolink1389_0-1698780982939.png

but i need that condition, cause it must sum only conceptoBG2 when the range of Cuenta its the same from dimesion