Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Variable with Parameters

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

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Solved

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

View solution in original post

2 Replies
Highlighted
Creator III
Creator III

Solved

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

View solution in original post

Highlighted
MVP & Luminary
MVP & Luminary

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