topic How to limit the data in a table using variable input box in App Development

How to limit the data in a table using variable input box

abc_18 — Sat, 16 Nov 2024 04:47:20 GMT

Hi,

I have created a input box, as a slider and I am using it in front end dashboard.

variable name is vTop10

Now I have a staright table, having one dimesnsion as 'Sales manger name', and multiple expressions.

I have to restrict the data in table based on input box selection, how to acheive this?

Thanks

Seyko — Wed, 04 Sep 2019 13:10:28 GMT

Hello,

Which do you exactly want to restrict? The values of the dimension, the calculations on your measures or both?

cordially.

Yoshidaqlik — Wed, 04 Sep 2019 13:10:55 GMT

would it decrease the number of rows in the table?
in your dimension put

Top10:

AGGR( if( Rank( your_expression ,4)<=$(vTop10), [Sales manger name] ) ,[Sales manger name])

Down10:

AGGR( if( Rank( your_expression * -1 ,4)<=$(vTop10), [Sales manger name] ) ,[Sales manger name])

Regards