topic Re: Dynamic Expression in QlikView

Dynamic Expression

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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..

sunny_talwar — Tue, 24 Jan 2017 01:26:47 GMT

May be this:

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

nareshthavidishetty — Tue, 24 Jan 2017 01:35:56 GMT

Hi,

Is the below approach is correct?'

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

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

Thanks..

sunny_talwar — Tue, 24 Jan 2017 01:40:06 GMT

I guess... but the expression would be

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