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

help with sum expressión

morning

i have a qw document where

i have the next expression, that works ok

(-(sum( {$<[FD_F_CUENTA_MAYOR] = {'70500002'},FD_F_FECHA_CONTABILIZACION={"=FD_F_FECHA_CONTABILIZACION=fechas"}>} FD_F_IMPORTE)))

now i need get that works to previous year

we have two fields (año(year) and mes(month) (2013  march) , when they are selected the variables:

fechas= 31/03/2013

fechas_prev_year= 31/03/2012

i just try to modify the expression but i didn´t get any.

(-(sum( {$<[FD_F_CUENTA_MAYOR] = {'70500002'},FD_F_FECHA_CONTABILIZACION={"=FD_F_FECHA_CONTABILIZACION=fechas_prev_year"}>} FD_F_IMPORTE)))

(-(sum( {$<[FD_F_CUENTA_MAYOR] = {'70500002'},FD_F_FECHA_CONTABILIZACION={"=FD_F_FECHA_CONTABILIZACION=fechas_prev_year"},Año= {$(#=Only(Año-1))}>} FD_F_IMPORTE)))

can you help me?

thanks and sorry for my english

regards

1 Reply
Gysbert_Wassenaar

Try disabling the selections in Año and mes:

(-(sum( {$<[FD_F_CUENTA_MAYOR] = {'70500002'},FD_F_FECHA_CONTABILIZACION={"=FD_F_FECHA_CONTABILIZACION=fechas_prev_year"}, Año=, Mes= >} FD_F_IMPORTE)))


talk is cheap, supply exceeds demand