How Divide this?

pgalvezt — Thu, 05 Mar 2015 18:32:32 GMT

Hi,

I have created many rows in QlikView with the wildmatch fuction and Concatenated.

Until now I have 3 rows ready.

Row A

Row B

Row C

The dimension created is called Reumen and the expression is called Sum(Real)*-1

I need to divide (Row A + Row B + Row C) / Row A

How has to be the next row? I know that in QlikView is impossible divide like I did below. But is for better Comprehenssion that what I want to do.

CONCATENATE (Resumen) LOAD

Departamento,

Sub_Departamento,

Cuenta_EERR,

Sub_Cuenta_EERR,

Cc_EERR,

'%' as Resumen

RESIDENT Real

WHERE wildmatch(Departamento,'A', 'B', 'C'/'A');

Thanks!

Re: How Divide this?

pgalvezt — Thu, 05 Mar 2015 18:51:14 GMT

Hi,

I have created an example the final number has to be 0,31 or 31% in the fourth row.

so 2027/6347

Thanks!

pgalvezt — Fri, 06 Mar 2015 14:37:58 GMT

Any Help?

Thanks!