topic can we call a macro function in a chart table ??? in expression/dimention ?? in QlikView

can we call a macro function in a chart table ??? in expression/dimention ??

Thu, 03 Jul 2014 09:00:41 GMT

hi all,

I have a very complicated macro and many functions in the same which are further build up with many variables etc.Now I want to call a function from it in a table dimention or expression area.Is this possible??? Else its too complicated to break up the whole function to smaller units in the table and then combine them to get the column required...

Can anyone please guide me??

regards,

sahana

Re: can we call a macro function in a chart table ??? in expression/dimention ??

Gysbert_Wassenaar — Thu, 03 Jul 2014 09:23:01 GMT

You can't call macro functions. But you can use variables. You can put expressions or part of expressions in variables and use the variables in other expressions. And you can pass parameters to variables. In the example below var1 accepts one parameter. In var3 the parameter passed to var1 is var2.

var1: sum( $1 Sales)

var2: {<Year={2014}>}

var3: $(vVar1( $(var2) )) * 1.05

Using this you can construct complicated expressions by defining parts as variables and (re)use the variables where ever you need that expression or expression fragment.

Re: can we call a macro function in a chart table ??? in expression/dimention ??

pljsoftware — Thu, 04 Aug 2016 14:29:57 GMT

Hi Sahana,

look this https://community.qlik.com/docs/DOC-4651#comment-48395

and look the attach.

Best regards

Luca Jonathan Panetta