Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)))
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)))
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)))
Thank you it worked for me.