Dimension code calc

[pgalvezt]

Hi, I have to replicate an Excel File. This requirement its impossible to me create a Straight table or pivote table because each dimension has a different code and the same Expression.

How to calculate "Ingresos"?

Dimension:

If

(ID = 19000 , Concept)

Expression:

Num

(
If( Calculo=1,

sum({$< Año={'$(xAñoMax)'}, Mes={'$(xMesMax)'}, Periodo= >} SaldoPpto*FactorEERR/Divisor),

Sum({$< Año={'$(xAñoMax)'}, Mes={'$(xMesMax)'}, TipoCalculo={1}, Periodo= >} SaldoPpto*FactorEERR)
/Sum({$< Año={'$(xAñoMax)'}, Mes={'$(xMesMax)'}, TipoCalculo={2}, Periodo= >} SaldoPpto*FactorEERR)

)
,
IF(Formato=3,'#.##0,00%', IF(Formato

=2, '#.##0,00', '#.##0;(#.##0)')))

Green Result: 89402

*******************************************************************************************************

"G. Bruta"

Dimension:

If

(ID = 39000 , Concept)

The Expression is te same Formula:

Green Result: 19473

Until now everything is fine, but now I have to divide "Ingresos/G Bruta" in another chart. My question is:

if it's the same formula in expression (Same Formula = score 100% ), how to tell QlikView dividing Gross Profit versus revenue?

I need to show the score in the chart where says No data to show. (Look at the picture)

Thank you!

[pgalvezt]

Hi, Any Ideas?

[pgalvezt]

Anyone?