How to limit values of list box

[#1]

Hi All,

I have 3 values for REGION column. Let values are A,B,C and corresponding sub-regions for 3 regions.in dashboard

I need to display only region A in list box of REGION and corresponding sub-regions of A in Sub-region filter list box.

how I should write a calculated dimension to display only A in REGION filter(listbox) and corresponding Sub-region of A in Sub-region

filter(list box).

Thanks in advance......

[alexandros17]

Write in both list boxes

if (Region = 'A', Region, null())

[#3]

how I can write for subregion....

[aveeeeeee7en]

Create 2 new fields in the Edit Script:

eg.

If(Wildmatch(REGION,'A',REGION) AS [Dashboard REGION]

If(Wildmatch(REGION,'A',SUBREGION) AS [Dashboard SUBREGION]

After Writing this in the Script Reload the Application, you'll get the desired Result and later you use these 2 fields in your Dashboard.

Regards

Aviral Nag

[MayilVahanan]

HI

Try like this

=If(REGION = 'A', REGION ) // region filter

=If(REGION = 'A', Sub-region) // subregion filter

[rustyfishbones]

IF(MATCH(REGION, 'A'),REGION)

[#7]

only({<Region = {'A'}>}Region)

and for sub-Region

only({<Region = {'A'}>}SubRegion)

and to write this in a listbox you have to chosse instead of a field all the way on the bottom something called formular should show up or calcualted (im not using QV in English so I'm not sure what it exactly says)

regards,

MT

[#8]

region-A,B,C.

Sub-region-E,F,G,H,I,J,K,L

where Sub-region E,F,G belongs to A

Sub-region H,I belongs to B

Sub-region J,K,L belongs to C.

I don't want to Hard-code Sub-region.because in future Sub-region may increases.

so I want dynamic expression to get only sub-regions belongs to A in aListbox

[#9]

yes you can do it like this

only({<Region = {'A'}>}SubRegion)

it is like you would select Region A in a listbox and then all the subregions for A would be shown.

regards,

MT

[#10]

thanks a lot Tammegger

what I need is I want to display only sub-regions of 'A' by default

with out selecting region-'A' .