topic Re: Using Inline table to make top N selection + all values in App Development

Using Inline table to make top N selection + all values

Stanislav1 — Fri, 15 Nov 2024 22:22:24 GMT

Hello there!

I will try to explain this issue to the best of my abilities. I have an inline table, which is connected to a button list, from where a user can pick a selection from 3,5,10 to show the top 10 values in a table.

Inline table

Front end table

How can I make a selection, where the user can see all of the values from the selected measure? Thank you in advance

Re: Using Inline table to make top N selection + all values

deepanshuSh — Thu, 10 Nov 2022 16:32:48 GMT

You can put an if and else condition, such as below in the limitation section and restrict the value based on the value section. Or in a better way create an variable and use variable input box for the same.

if(Value =3, 3,
if(Value=5, 5,
if(Value=10, 10)))

Re: Using Inline table to make top N selection + all values

vinieme12 — Fri, 11 Nov 2022 04:26:37 GMT

Add Another Selection Value

_TopN:

load * Inline [

_rank_ID,_rankValue

1,3

2,5

3,10

4,ALL

];

Then instead of using Field Limitations use a Measure as below

=if(_rank_ID=4,sum(somemeasure) , if(rank(sum(somemeasure),4,2)<= _rankValue , sum(somemeasure)))

Re: Using Inline table to make top N selection + all values

Stanislav1 — Fri, 11 Nov 2022 07:36:59 GMT

Thank you it worked for me.