topic Re: Problem with a Set Analysis in QlikView

Problem with a Set Analysis

Anonymous — Thu, 30 Aug 2018 12:38:29 GMT

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.

Re: Problem with a Set Analysis

vamsee — Thu, 30 Aug 2018 18:22:11 GMT

May be try

SUM({$<[DESC_GRUPO_B] = {'INGRESOS'}, MES={"$(vMes)"}>}IMPORTE)*-1

Re: Problem with a Set Analysis

Anonymous — Thu, 30 Aug 2018 18:27:22 GMT

Resolved!, This solution worked well. Thank you.

Re: Problem with a Set Analysis

vamsee — Thu, 30 Aug 2018 18:29:09 GMT

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.