Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

jtrillori
New 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

Re: help with sum expressión

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
Community Browser