Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shanemichelon
Partner - Creator II
Partner - Creator II

Set Analysis - Dual field numeric comparison

I have a question about using set analysis with DUAL field.  Say I have a field called FY (Financial Year).  Lets say it is a dual with values like:  Text(FY) = '2018/2019', Num(FY)=25

Ie an autonum representing the numeric version and text for the human version.

Lets say I want to get a specific year:

Sum({$  <FY={15} > }  Amount)

This does not work.  I think it is because it is a Dual field.  Thoughts?

Labels (1)
1 Solution

Accepted Solutions
zzyjordan
Creator II
Creator II

Hi,
Try this
Sum({<FY={">=15<=15"}>} Amount)

ZZ

View solution in original post

2 Replies
zzyjordan
Creator II
Creator II

Hi,
Try this
Sum({<FY={">=15<=15"}>} Amount)

ZZ
shanemichelon
Partner - Creator II
Partner - Creator II
Author

Thanks. Yes I considered that and I think it will work, but for the purposes of example, I simplified the actual case. In actuality it would be is something more like:
Sum( {$ <FY={">=$(=Max(FY)-1)<=$(=Max(FY)-1)}>} Amount)

I guess that's ok, but it seems like a work around.