two fields in two diagramms on one page

[#1]

hey there,

it is very easy to get a diagram with one field...

i tried to combine two fields with a "&" but the solution is that both fields are in one diagram... but i want to have two fields in two diagram on one page. - i it possible?

Because i want to compare two different fields.

Can somebody help me? thanks a lot!

[#2]

hey swuehl,

it is too complicated to show a example qvw...

when i put this =Subfield($(="fieldname"),'|',1) into the dymension, it will work for only one selected field. if i select two fields, it doesn't work... error in dynamic dimension

if i put this =Subfield($(="fieldname"),'|',2) into the second diagram it shows me something, but not the truth. it came an error in dynamic dimension...

maybe you can help me?!

[#3]

when i put =Subfield($(="~appDim2.ID"),'|',1) into a textbox and select two fields, it comes an error message:

"Error: Error in expression: ')' expected" - you know why?

[swuehl · Accepted solution]

Why don't you try what I suggested above:

=Subfield( Concat(DISTINCT FieldName,'|'),'|',1)

resp.

=Subfield( Concat(DISTINCT FieldName,'|'),'|',2)

[petter]

What is your fieldname here? Is it ~appDim2.ID  ? 
Furthermore you have to get the Concat() function working as soon as the field has more than one selected value this expression will break unless you use Concat() or another aggregation function that makes sense.

[#6]

because it came an "error in dynamic dimension" !!!

it shows the diagram above, but it should like the bottom one

[swuehl]

That expression is for checking your two selected values.

Don't use it as a calculated dimension, since it won't return a dimension, but single values.

Use it e.g. in a text box or in conditional expressions to hide / show your expressions / charts.

[#8]

okay, thank you.

Can you tell me, which command i have to use that returns a dimension value?!

Is this possible with set analyses? I dont get the correct syntax...

i tried this for the first: {$<fieldname={"*up"}>}getfieldselections(fieldname)

and the second: {$<fieldname={"*down"}>}getfieldselections(fieldname)

[#9]

yes, i believe you and i tried this (swuehl told me):
=Subfield(Concat(DISTINCT $(="~appDim2.ID"),'|'),'|',1)

but it doesn't work for the dimension...

[#10]

i got the solution! yeah!

with the $ expansion you get the content of the field.

Thank you very much swuel for support!

i put this into the dimension: =$(=Subfield(Concat( [fieldname],'|'),'|',1))