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!
