Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
New-Qlik
Creator III
Creator III

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 III
Creator III
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 III
Creator III
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,'~','$')