Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a question with a set analysis.
I have two analyzes to do on a sum, I have to add the income in one period.
For this I made the following formula
=SUM({$<[DESC_GRUPO_B] = {INGRESOS},MES={$(=only(vMes))}>}IMPORTE)*-1
In this case "vPeriodo" is a variable that I bring from the scrip, even if it can be taken out by formula would be better.
But I do not know what can be wrong that is not correctly performing the sum, it says 0.
I hope you can help me.
May be try
SUM({$<[DESC_GRUPO_B] = {'INGRESOS'}, MES={"$(vMes)"}>}IMPORTE)*-1
May be try
SUM({$<[DESC_GRUPO_B] = {'INGRESOS'}, MES={"$(vMes)"}>}IMPORTE)*-1
Resolved!, This solution worked well. Thank you.
Glad to hear it worked for you.
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.