Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fiscal year syntax set expression

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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Use the below Expression:

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

View solution in original post

4 Replies
tresesco
MVP
MVP

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
Partner - Specialist
Partner - Specialist

Hi,

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

try below syntax

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

Not applicable
Author

hi i have attached the sample app

tresesco
MVP
MVP

Use the below Expression:

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