Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working on a dashboard where we are using alternate states and I am able to pass most of the selections to my "state1" from the default by using '('&getfieldselections(%Dim,'|')&')' inside a couple of triggers, but whenever the selection has two words it does not work
has anyone seeing this issue before ?
I found a work around for this issue
I created an id field without any spaces between it, and on my triggers I switched it to do a concat of ID field and pass that to the second state, then I clear the dimension field from my second state (this is done to get rid of the previous selections in this state) and as last step I select the possible values for the dimension I need in the second state
It seems to work, if you delete the State 1 and replace it by a State-Name without spaces e.g. State1
Hi Daniel,
The selections are the ones that have the spaces and not the statename.
Let's say I have a city dimension and it contains New Orleans,Dallas,Atlanta and New York.
If I select all of them in my default state I want these selections to be passed to my second state, though only Dallas and Atlanta are passed
I found a work around for this issue
I created an id field without any spaces between it, and on my triggers I switched it to do a concat of ID field and pass that to the second state, then I clear the dimension field from my second state (this is done to get rid of the previous selections in this state) and as last step I select the possible values for the dimension I need in the second state