topic Re: Problem with MIN between user field selection in App Development

Problem with MIN between user field selection

thiago_miranda — Mon, 27 Aug 2018 18:46:27 GMT

Hello, i have the following data:

table:

LOAD * INLINE

[

id, name, year

1, a, 2015

2, a, 2016

3, a, 2017

4, a, 2018

5, b, 2016

6, b, 2017

7, b, 2018

8, c, 2017

9, c, 2018

]

When the User filters by year:

what i need is the minimal value in the User selection interval:

a 2015

b 2016

c 2017

I can't use {1} because it ignores the user selection. I tried $<year={$(=(MIN(year))}> but i got nulls for b and c

Thank you.

Thiago_Justen_ — Tue, 28 Aug 2018 00:33:28 GMT

Thiago,

You could try somenthing like this:

Min(Aggr(Year),name))

FirstSortedvalue(Year,Aggr(Year,name))

thiago_miranda — Tue, 28 Aug 2018 15:00:39 GMT

I tried your suggestions and

FirstSortedvalue(year,Aggr(MIN(year),name))

but got the same result.

thiago_miranda — Tue, 28 Aug 2018 15:14:37 GMT

After some testing i found it:

Min({<year={">=$(=MIN(year))"}>*<year={"<=$(=MAX(year))"}>}year)

It should be the intersection operator or else global minimums are shown.

Thank you for your attention.

Thiago_Justen_ — Tue, 28 Aug 2018 16:37:55 GMT

Great man!