Variable with Parameters

[cristian_av]

Hi I have a expression that I use on certain graphs, but I want to convert it to a variable variable with parameters. This is the original expression (working):

= Sum({<PeriodoNumVol = {">=$(=min(PeriodoNum))<=$(=max(PeriodoNum))"},[Tipo Registro]=,[OrigenVol]={'Vol.Real'},TipoVol={'Generado'},PeriodoNum=,Periodo=>}VolumenReal)/1000

This is how I've defined my variable:

= Sum({<PeriodoNumVol = {">=$(=min(PeriodoNum))<=$(=max(PeriodoNum))"},[Tipo Registro]=,[OrigenVol]={$1},TipoVol={'Generado'},PeriodoNum=,Periodo=>}VolumenReal)/1000

And how I use it in the expression of graphs.:

=$(Volumen('Vol.Real'))

Any idea why it is not working?

Thanks!!!

[cristian_av · Accepted solution]

Solved

I was using  the equal (=) in var and in expression,

[rwunderlich]

1) Place the =$(Volumen('Vol.Real')) expression in a straight table.

2) Leave the Label value blnk for this expression.

3) Hover over the column heading to see the expanded expression. Does it look correct? If not, correct it. If it looks correct, right click - copy cell to clipboad and paste the expanded expression in a Text Ojbect to debug.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com