Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi samir,
you might want to take a look at the conditional functions, especially match / mixmatch / wildmatch.
maybe something like
count(if(wildmatch (projectsfield, '*' & 'Alt 1' & '*')>0,1))
Stefan
But that only solves the count in the diagram. I would like to make a Field object where the user can choose from the alternatives:
Alt 1
Alt 2
Alt 3
Maybe i didnt understand you correct, if so could you explain more detailed?
Alternatively, you could probably use a set expression like
count ({<projectsfield = {"*Alt 1*"}>} projectsfield)
hei
attach is an example
using the subfield function in the load script
you should note that it creates more then one record for project
so this table sholud be conected to the project table and not join
hope its helps
Thanks for the example, I think that helps.
Still I don't understand your requirement.
If a add a list box with field ProjectCategory to the sheet, do I have a field object like you desire to choose Category from?
And what measure do you want to be calculated at what place (e.g. new table column or text box)?
Sorry If I am a bit slow today.
Stefan
Maybe something like this?
I removed the subfield and added a table with just projectCategory manually (you could probably get it from your DB easily).
Then added mentioned list box and a chart table with expression like mentioned before.
Cheers,
Stefan
Look at the picture.
As you se i have each uniqe combination.
What i would like tho show is:
Alt 1:
Alt 2:
Alt 3:
and when pressing for example alt 1 i would like to show the sum(value) for every project where Alt 1 are presented.
Hi samir,
thought I was close...
Hm, just added some values to my data and prettied up the charts.
Maybe like attached sample app? (Still not sure what you are after)
It might be an idea to get rid of the concattenated strings and use a many to many linkage table instead (but that's probably not the problem we are talking about).
Regards,
Stefan
Me again,
if you don't like my inlined ProjectCategory table, you might use
Category:
Load Distinct
SubField(CategoryMix,';') as ProjectCategory
resident Project;
instead.
Regards,
Stefan