topic Ignore Selection in Dimension using filter pane in App Development

Ignore Selection in Dimension using filter pane

kavirao — Tue, 05 Oct 2021 19:41:21 GMT

Need suggestions.

I have 2 filter panes One for State and another for Cities. Both the filter pane is allowed to select only one value.

State	City
NJ	ABC
NJ	XYZ
PA	RRR
PA	YYY
NJ	EEE
PA	TTT

Both State and City filter pane placed in Tabbed Container.
Both fields State and City enabled select only one value in field properties.
Either one of table is visible to user.

On select of State Filter pane should not change city filter pane. It has to list all cities ignoring selection of state.
If I select City corresponding State needs to be changed in State, as One value field property enable in STATE.

On based on the selection I have 20 Charts will be displayed in the sheet. I cannot perform using Alternate State option.

Please provide suggestions to implement this.

Kavitha

Re: Ignore Selection in Dimension using filter pane

Digvijay_Singh — Wed, 06 Oct 2021 03:42:48 GMT

It looks quite complex and looks contradicting when you want to ignore selection in the city filter pane but city has always one selected value checked.

Wanted to try something like Aggr(only({<State=>}City),City) in the City filter pane but select only one value make things difficult.

Hope other community experts will be able to help.

Re: Ignore Selection in Dimension using filter pane

Digvijay_Singh — Wed, 06 Oct 2021 03:46:57 GMT

Missed'1' to show all values, Aggr(only({1<State=>}City),City), but I know it won't help though to achieve the expected..

Re: Ignore Selection in Dimension using filter pane

kavirao — Wed, 06 Oct 2021 13:28:04 GMT

thank for response, yes require better solution it doesn't work as expected.

Let see if anyone had faced this kind of requirement.

Re: Ignore Selection in Dimension using filter pane

valishaik1985 — Mon, 14 Aug 2023 09:04:18 GMT

Hi Digvijay,

I am also facing same kind of issue, my filter pane selected always only one value other values not displaying. clear all selections then select another and only one at a time .

Is there any possibility to make multiple selections?

In my calculated dimension used something like IF(Aggr(Count( value), function)>0, function).

Regards,

Khasim