Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Why don't using a simple listbox for this instead of four buttons with complex logics?
- Marcus
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?
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?
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
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?
Such matching should be done within the script - I think this will be really helpful for you:
Unbalanced, n-level hierarchies
- Marcus
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?
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
];