Button

[#1]

Hi All,

Four buttons I have

All AMERICA EMEA APAC

when All is selected it should select AMERICA, EMEA, APAC
but if no data for EMEA and APAC, it should display AMERICA, instead if no value for either one region it is not selecting the All button

it should display AMERICA in All if no data for EMEA and APAC.

Can anyone help me on this?

[marcus_sommer]

Why don't using a simple listbox for this instead of four buttons with complex logics?

- Marcus

[jonathandienst]

Selecting nothing is the same as selecting All. This is the default QV behaviour. I agree with Marcus - why add complex logic for something which is already managed by QV?

[#4]

ok agree with you and marcus, but how can i ge All field in my region, all should hav data for all three region. how do i calculate it?

[marcus_sommer]

For the most calculations like sum(value) or count(order) you don't need to worry - everything will be correct calculated to the available data.

- Marcus

[#6]

actually i want to give field name as ALL if Region is america, apac and emea so finally i will have four fields in Region filter ALL,AMERICAS,APAC,EMEA, how can i acieve this?

[marcus_sommer]

Such matching should be done within the script - I think this will be really helpful for you:

Unbalanced, n-level hierarchies

- Marcus

[#8]

How about this as an idea, have a list box displaying the regions, and have a button above that with an action behind it of 'Clear Selection - Region'. This gives users the ability to dissect data by region but also to select all regions. What do you think?

[nagaiank]

Create the following table and the list box on the lb_region field:

load * inline [

lb_region, region

AMERICAS, AMERICAS

APAC, APAC

EMEA, EMEA

ALL, AMERICAS

ALL, APAC

ALL, EMEA

];