Can GetFieldSelections() be used as a dimension?

[#1]

Hi,

I am trying to use GetFieldSelections() to build a dimension, however it only works when Selection=1. Is there a way use it as a list of selected values?

I mean in a text box it works fine and it gives me a list of all values selected.

Any ideas?

Regards

Rahul

[#2]

you need to post a sample qvw file:)

[#3]

Not that I have found, I spent quite a while working on this, you can't make a clickable dimension out of it.

[#4]

Dear Pari,

Please find QVW atttached.

Regards

R

[swuehl]

Use set analysis with implicite field value definitions ( p() and e() functions) instead.

Something like:

=sum({<Employees=p()>}Sales)

=sum({<Employees=e()>} Sales)

edit:

and here is how you can create a synthetic dimension from your Fieldselections (if absoultely needed)

[#6]

Thanks Swuehl, i tried using the following as a dimension:

= if(Fruit= valuelist($(vFruitSelection2)),'Test','Control')

However it only gives me Test as a dimension. Do you see any reason why?

Please help!

Regards

Rahul

[Anonymous]

Not exacly what you are looking for, but a workaround to get the same result is to get a trigger on the field Fruit

(Settings >> document properties >> Triggers : Field Event Trigger)

And add here an action Select Excluded on the field Fruit.

[swuehl · Accepted solution]

I am unsure what you want to achieve, could you describe your requirements for the final chart?

maybe like attached?

[#9]

Thanks Stefan, i got the view i wanted. The following is what i used for the dimension:

aggr (if(sum({<Fruit=e()>}sales)>0,'Control',if(sum(if( valuelist($(vFruitSelection2)) = Fruit, sales) )>0,'Test')),Fruit)

Regards

Rahul