Make a listbox with excluding values

[prat1507]

hi All

My query is if I've a listbox say Fruits

Fruits:

Apple

Banana

Pineapple

Mango

Strawberry

I want to Create a listbox as:

Fruits:

Apple

Banana

Pineapple

Mango

Strawberry

Not Mango

If someone selects Not Mango, it must reflect in all the charts showing + I must be able to select Not Mango and Banana together.

Any kind of help will be appreciated. Thanks in advance.

Regards
Pratyush

[techvarun]

Please try the attached

[techvarun]

Expression used : =aggr(Only({1-$} Fruits),Fruits)

[ahaahaaha]

Hi Pratyush,

May be like at attached file?

Regards,

Andrey

[prat1507]

Hi Andrey, I dont want to make changes to the charts but handle it through the list box only. There are too many charts and it is not possible to change the expression everywhere.

Regards
Pratyush

[prat1507]

Any other solution?

[Anil_Babu_Samineni]

Where this "Non Mango" coming from? Does this same table / diff table?

I assume, You need some charts displaying. Can you describe more how you want to show even selection from filter

[prat1507]

So No Mango represents every other value than Mango. Lets' say if I have data as

Fruits, Trees

Apple, 10

Banana, 20

Pineapple, 30

Mango, 40

Strawberry, 50

I want to create a listbox such that it contains the below values

Apple

Banana

Pineapple

Mango

Strawberry

No Mango

If someone selects No Mango in the filter, the expression Sum(Trees) would return

110 (150-40)

If No Mango is selected, one should be able to select the other value ex. Apple

it means No Mango and Apple are selected together

and it should show the Sum as 10.

Regards
Pratyush

[Kushal_Chawda]

I think you need to write some script to achieve this

Data:

LOAD * Inline [

Fruits, Trees

Apple, 10

Banana, 20

Pineapple, 30

Mango, 40

Strawberry, 50];

Concatenate

LOAD 'No Mango' as Fruits,

    Trees

Resident Data

where Fruits<>'Mango';

Now you can use the Fruits in lisbox

[arvind_patil]

Hi Pratyush,

Please find the attached app.

Thanks,

Arvind Patil