Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Button

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?

Tags (1)
8 Replies

Re: Button

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

- Marcus

MVP
MVP

Re: Button

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?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Button

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?

Re: Button

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

Not applicable

Re: Button

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?

Re: Button

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

Unbalanced, n-level hierarchies

- Marcus

Not applicable

Re: Button

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
Valued Contributor III

Re: Button

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

];

Community Browser