topic Variable with Parameters in QlikView

Variable with Parameters

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Variable with Parameters

cristian_av — Fri, 06 Jan 2017 18:38:20 GMT

Solved

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

Re: Variable with Parameters

rwunderlich — Fri, 06 Jan 2017 18:40:26 GMT

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