topic Re: how to hide above values after selection made in App Development

how to hide above values after selection made

siri087 — Thu, 04 Jul 2024 07:23:31 GMT

Hi All,

Hope you doing well.

I am struck at one place where I need to hide the above unselected values from the filter panel.

Given is the below example

So, if the user selects Value "D" from the ID column, then the values "A, B, and C" should be hidden. Only the values after "D" should be visible to the user for selection. Also, users should be able to select only two values from the ID column.

Re: how to hide above values after selection made

MatheusC — Thu, 04 Jul 2024 12:30:02 GMT

@siri087

Insert the aggr() function in your field, leaving it like this,
change to your dimension.

=aggr(Field,Field)

-Matheus

Re: how to hide above values after selection made

siri087 — Fri, 05 Jul 2024 07:13:22 GMT

Hi, @MatheusC ,

Thanks for your response.

Its not working as expected . if we select the value "D"(left side) i only get a "D" value (right side) filter . As i need to see "D" to "I".

Re: how to hide above values after selection made

salmankojar — Fri, 05 Jul 2024 09:05:03 GMT

Hi @siri087 you can use below expression in your dimension fx of your filter objects.

=if(GetSelectedCount(ID) = 0, ID,
if(GetSelectedCount(ID) = 1,if(ID >= GetFieldSelections(ID), ID)))

Re: how to hide above values after selection made

siri087 — Fri, 05 Jul 2024 10:57:37 GMT

Hi, @salmankojar ,

Thanks for Quick response

I am able to see the rest of the values after the selection was made, but the other values are in gray (right filter). So can we show them as available for selection?

if we select "E" and "F" , we still need to see "G," "H,and "I," as they are below the selected values

Re: how to hide above values after selection made

salmankojar — Fri, 05 Jul 2024 11:15:36 GMT

Hi @siri087 ..that is your requirement. User should be able to select only two values from ID column.

Re: how to hide above values after selection made

marcus_sommer — Fri, 05 Jul 2024 11:27:42 GMT

Why should the user not directly select the wanted values?

Re: how to hide above values after selection made

siri087 — Mon, 08 Jul 2024 06:05:58 GMT

Hi @marcus_sommer ,

there is nothing called unwanted .

If the user selects any values initially, the below values only need to be visible for the next selection. user should not select more than 2 values in the filter .

Re: how to hide above values after selection made

marcus_sommer — Mon, 08 Jul 2024 07:15:23 GMT

By using one field - there is no initial selection and following on-top selections possible else the following selections will extend or exclude the initial one. If you want to use some kind of hierarchy you will need at least two fields. I suggest you elaborate the aim with real field-values a bit more detailed.