Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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