Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

May be this:

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

View solution in original post

3 Replies
Highlighted

May be this:

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

View solution in original post

Highlighted
Creator III
Creator III

Hi,

Is the below approach is correct?'

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

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

Thanks..

Highlighted

I guess... but the expression would be

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