topic Create an Expression with multi substracting in QlikView

Create an Expression with multi substracting

Tue, 17 Feb 2015 14:26:34 GMT

Good morning, I need to do the following:

I have a field called CAUSALE that can take multiple values (FE, IN, NC, IP).

I have to create an expression to perform a subtraction between a field called CNIMPF and field CNRATA when CNCAU has a certain value (IN or IP). The subtraction can have more of a subtracting based on how many are the occurrences of the value IN in the field CNCAU

For example it's possible to have this situations:

CNIMPF - (CNRATA-CNRATA-CNRATA-CNRATA-CNRATA)

CNIMPF - (CNRATA -CNRATA-CNRATA)

CNIMPF - (CNRATA)

It's possible to do ?

Thanks

Giovanni

Re: Create an Expression with multi substracting

sunny_talwar — Tue, 17 Feb 2015 14:30:16 GMT

Not exactly sure what you are trying to accomplish here, would you be able to give an example here? (May be a sample qvw)

Best,

Re: Create an Expression with multi substracting

MK_QSL — Tue, 17 Feb 2015 15:21:10 GMT

Can you provide sample data along with your exact expectations?

Re: Create an Expression with multi substracting

Wed, 18 Feb 2015 08:50:37 GMT

Hi, I attache an example of a file.

What I do is this:

The field RESIDUO is the difference of the FIELD "IMPORTO FATTURA - IMPORTO SCADENZA".

In case there are two lines in this case for the field "NUMERO FATTURA", you need to either the residual is calculated as "IMPORTO SCADENZA" where field CAUSALE is "FE" less "IMPORTO SCADENZA" where the field is equal to IN.

It 'possible that there are multiple lines for the field "CAUSALE" equal to "IN".