Dimension code calc

pgalvezt — Wed, 27 Jun 2012 20:24:11 GMT

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:

(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:

(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!

Re: Dimension code calc

pgalvezt — Thu, 28 Jun 2012 13:23:29 GMT

Hi, Any Ideas?

Re: Dimension code calc

pgalvezt — Thu, 28 Jun 2012 16:11:19 GMT

Anyone?

topic Dimension code calc in QlikView

Dimension code calc

Re: Dimension code calc

Re: Dimension code calc