Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Creator II
Creator II

Re: Set Analysis - Dual field numeric comparison

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

ZZ

View solution in original post

2 Replies
Highlighted
Creator II
Creator II

Re: Set Analysis - Dual field numeric comparison

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

ZZ

View solution in original post

Highlighted
Partner
Partner

Re: Set Analysis - Dual field numeric comparison

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.