Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would need some help with a set analysis expression.
My source data is:
I have a variable named vFecha = 20150120
Would need an expression that calculates the sum of imp by DES_NEGOCIO (dimension in graph) for records that:
Selected records should be highlighted in yellow:
Thank you very much.
-----------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------
Hola,
necesitaría ayuda con una expresión de set analysis.
Mis datos de origen son:
Tengo una variable llamada vFecha = 20150120
Necesitaria una expresion que calculase la suma de imp por DES_NEGOCIO (dimension en el grafico) para los registros que:
Los registros seleccionados deberían ser los resaltados en amarillo:
Muchas gracias.
can you please provide the sample app ??? I did not tried with data
The source and app
Hi,
After lot of customization I got the Solution please find the attachment for the same
Hi,
thank you very much but does not work if you change the variable vFecha
sorry check this
sorry but it doesnt work fine.
The solutions for two example should be:
Thank you
Hi,
any suggestion about this?
Thank you very much
Hi,
Sorry i was bit busy
try this expression this should work
if(FLAG='A' ,sum({<FEC_MODIF={"=Aggr(nodistinct max(FEC_MODIF),PK)"}>}IMP))
Hi
Did it solve your issue??
If so please mark it as helpful or correct and close this thread
Hi,
it is not working ok. It does not select only the max(FEC_MODIF) where FEC_MODIF <= vFecha. It is selecting all the records aggregated by PK where FEC_MODIF <= vFecha
For example, if you choose vFecha=20150118 the expression select also the record:
when the max(FEC_MODIF) where FEC_MODIF <= vFecha (20150118) is this one (and just it):
Anyway, thank you very much for the help.