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

inline Expression calling in expression

Hello 

 

I have Inline table 

Load * Inline [ Expression_Id, ExpressionTY, ExpressionLY
             1, 'sum({$<Date ={'$(=Date(Max(Date)-1))'}>} "Sales " )',  'sum({$<Date ={'$(=Date(Max(Date)-366))'}>} "Sales " )',
             2, ............

];

 

when i call this expression in an chart expression using  '=$(=ExpressionTY)'

its gives me output without considering date condition means sum(Sales) till now for both the expressions.

1 Solution

Accepted Solutions
New-Qlik
Creator II
Creator II
Author

Thanks Anushree for replying but its didnt work. 

Now i have replace $ with in inline and in chart expression i used this n it worked 

Replace(Expression_TY,'~','$')

View solution in original post

2 Replies
anushree1
Specialist II
Specialist II

Try Using:

sum({$<Date ={"$(=Date(Max(Date)-1))"}>} Sales  )

and invoke the expression as =$(ExpressionTY)

New-Qlik
Creator II
Creator II
Author

Thanks Anushree for replying but its didnt work. 

Now i have replace $ with in inline and in chart expression i used this n it worked 

Replace(Expression_TY,'~','$')