topic Fiscal year syntax set expression in QlikView

Fiscal year syntax set expression

Tue, 20 Aug 2013 11:34:05 GMT

Hi!

i have the following fields in my datamodel

fYear : Shown as Following 2014 (Represents 2013/2014 fiscal year)

FYear : Shown as following 2013/2014

i would like my set analysis calculations to work with the FYear field as it is easier to select and understand for the user.

my current syntax works with the fYear however when try with FYear i get 0 i think it has to do with /.

Current Syntax Below;

=sum({$<fYear=, fYear={$(=max(fYear))}>}Nettobelopp)

Best,

Brad

Message was edited by: Bradley Coyne

tresB — Tue, 20 Aug 2013 11:42:11 GMT

Can you please share your sample app?

I guess that is not working because of the format, i.e. the max(FYear) result is not coming as in the FYear field, you need to take care of that.

kumarnatarajan — Tue, 20 Aug 2013 11:53:15 GMT

Hi,

I think it is format problem. so check your format.

try below syntax

=Sum({$<fYear={"$(=Year(Max(fYear)))"}>}Nettobelopp)

Tue, 20 Aug 2013 12:09:52 GMT

hi i have attached the sample app

tresB — Tue, 20 Aug 2013 12:23:23 GMT

Use the below Expression:

=sum({$<FYear=, FYear={"$(=Dual(Max(fYear)-1 &'/'& Max(fYear), Max(fYear)))"}>}Nettobelopp)