Help with multiple choise field

[#1]

I hava a field in the database where the user can choose from multiple alternatives.

Example:

Field:

Alt 1

Alt 2

Alt 3

The user can now choose from the alternatives in the box and the choise is saved in the database in same field with the seperatert ;

Example: ;Alt 1;Alt 3;

Lets say that a project table have this multiple field. And now users create projects and choose differnt combinations for each project.

If i load this infomration into QV it will make one alternativ for each uniqe combination. So if i dispolat this field in a QV document it will look something like this:

;Alt 1;

;Alt 1;Alt 2;

;Alt 1; Alt 3;

;Alt 2; Alt3;

;Alt3;

Now i want to know how many projects is Alt 1 represented in. If i choose Alt 1 in the field above it will only show me project where ONLY Alt 1 is chosen. But i have other project where Alt 1 is on of many multiple chooises.

I'll hope that somebody could help mw with this. If i have explained it to bad dont hesitate to ask for further information.

Thanks!

I would now like to

[#2]

I have look inte your solutions and we are getting close but not close enough

Now when i choose Alt 1 it will show me costs in 3 different bars.

I would like it to show only one bar and there it will sum all values where Alt 1 is presented. So intead of 3 bars (Alt 1, Alt1;Alt2;Alt3 and Alt1;Alt3)

Dont know if I maybe explanin it to bad for you to understand.

But a real life situation would be.

Company is selleing 3 products in different projects. In each project there could be mixes of these 3 products.

PROJECT     PRODUCT

Project 1     Prod1; Prod 2

Project 2     Prod 3

Project 3     Prod 2; Prod 3

Now i want a box in QV where I can choses from the three different products.

I want a to count the number of projects where the product is presented.

Exmaple:

Press Prod 1 --> Result: 1

Press Prod 2 --> Result: 2

Press Prod 3 --> Result: 2

So i want to count how many times is the choosen product presented in a project.

[swuehl]

Hi,

maybe like this (for example put complete below expression as expression in a text box):

='Selecting Category '& concat(ProjectCategory,' & ') & chr(10) &

' results in '

& count(aggr( if(WildMatch(CategoryMix,'*'&ProjectCategory&'*')>0,1 ) ,Project))

& ' projects'

Regards,

Stefan

P.S: Again, it would also be possible to link the ProjectCategory to the Data with an additional table, to decide what is better, it depends what you want to achieve

[swuehl]

Hi,

I forgot that you also want that total bar graph.

Please find attached sample qvw.

As I understood, you want a single value selection for project category, right? If not, should it be a OR or AND selection?

Ciao,

Stefan