topic variable with parameters in QlikView

variable with parameters

tgumbing — Wed, 18 Oct 2017 12:41:37 GMT

Hi,

I have a variable with 2 parameters :

FuncCal=SUM({<Year={$1}, Month={$2} >} TimesValue)

And when I call it in my Pivot Table it's not working :

=$(FuncCal(max(YearSelect),max(MonthSelect)))

Can some one help me ?

Thanks

sunny_talwar — Wed, 18 Oct 2017 12:57:51 GMT

May be change the variable to this

FuncCal=SUM({<Year={"$(=$1)"}, Month={"$(=$2)"}>} TimesValue)

tgumbing — Wed, 18 Oct 2017 13:20:10 GMT

Thanks