Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

2 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
pljsoftware
Creator III
Creator III

Hi Sahana,

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

and look the attach.

Best regards

Luca Jonathan Panetta