
Expression to get the SUM on the First Month...I'm very close
alejandro hernández Nov 8, 2011 11:48 AM (in response to Roberto Figueroa)I didnt understand very well what you need. Could you post an excel with an example?

Re: Expression to get the SUM on the First Month...I'm very close
Roberto Figueroa Nov 8, 2011 1:13 PM (in response to alejandro hernández)sure,
In the column Total_FirstMonth (F) what I need is the same value from column C which is the SUM(TotalPago) for the first MesAnio for each InsumoKey.
In the QV example that column has the correct value except for the two rows where InsumoKey = "ACH030"
In the excel example I've yellow colored this two rows.
thank you.
Roberto

example.xlsx 8.7 K

Expression to get the SUM on the First Month...I'm very close
Gabriela Morales Nov 8, 2011 1:31 PM (in response to Roberto Figueroa)Hi Roberto,
Try with this: SUM ( {$<MesAnio = {"=sum(TotalPago)>0"} > } TotalPago )
Hope this helps,
Regards!

Expression to get the SUM on the First Month...I'm very close
Roberto Figueroa Nov 8, 2011 1:54 PM (in response to Gabriela Morales )Thank you Gabriela, but I think you didn't understand my problem.
did you see my excel example...?
that's what I want to get.
thank you
Roberto

Re: Expression to get the SUM on the First Month...I'm very close
Gabriela Morales Nov 8, 2011 4:15 PM (in response to Roberto Figueroa)Hi Roberto,
Here is a solution
Hope this helps
Regards!

testCompras_reduced.qvw 226.5 K

Expression to get the SUM on the First Month...I'm very close
Roberto Figueroa Nov 8, 2011 4:29 PM (in response to Gabriela Morales )Thank you Gabriela, but it doesn't work if a change order on MesAnio column.

Re: Expression to get the SUM on the First Month...I'm very close
Swarup Malli Nov 8, 2011 4:34 PM (in response to Gabriela Morales )Gabriela,
That was a excellent expression u wrote,
What is the Above function used for ?
Regards
Swarup

Expression to get the SUM on the First Month...I'm very close
Gabriela Morales Nov 8, 2011 4:41 PM (in response to Swarup Malli)Hi Swarup,
Above(expr) evaluates the expression with the dimension values from the row above the current, you can find more info and examples in the QlikView help
Regards!

Re: Expression to get the SUM on the First Month...I'm very close
Swarup Malli Nov 8, 2011 4:44 PM (in response to Gabriela Morales )Thank u , Gabriella
Regards
Swarup






