Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to count number of selected items in prompt/presentation variable

Hi Experts,
Is there any way we can count number of selected values in prompt/presentation variable?
Requirement is:
When user select single country,currency prompt should display appropriate currency code values.
If user select more then one country ,then currency prompt always should be USD.
Thanks,
Answers
-
cant you find(locate) the comma in the variable data and assign USD if you find a comma in the variable value?
0 -
something like below
case when POSITION(',' IN '@{yourVariable}')>0 then 'USD' else yourcurrencycolumn end
Thanks
Aj
0 -
How to limit prompt based on other selected prompt values(Single/Multiple)
What's the point of this new thread asking the same thing for which you got an answer on the original one? Instead of losing your time in new thread keep following up on the original one.
You got the answer there already.
0