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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Dynamic Expression

Hi,

How to make the below expression as dynamic.

sum({$<FISCALYEAR={"FY2016"}>}Qty)

For ex: on 02/01/2017 the FISCALYEAR should changed to FY2017 which i need to do it dynamically.

Thanks..

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Sum({$< FISCALYEAR = {"$(='FY' & Year(YearStart(Today(), 0, 2)))"}>} Qty)

View solution in original post

3 Replies
sunny_talwar

May be this:

Sum({$< FISCALYEAR = {"$(='FY' & Year(YearStart(Today(), 0, 2)))"}>} Qty)

nareshthavidishetty
Creator III
Creator III
Author

Hi,

Is the below approach is correct?'

In Script: right(FISCALYEAR,4) as Year,

In Chart : sum({<Year={'=max(Year)'}>}Qty)

Thanks..

sunny_talwar

I guess... but the expression would be

Sum({<Year = {$(=Max(Year))}>} Qty)