Hi,
Here I gave drill order as Year–>Month–> Currency.
My requirement is to get “All” in currency combo box and when I click on that I should display all currencies and related values which I have. Here I’m using Qaaws Connection to retrieve the data.
Please, do me the needful.
Regards,
Prasanna.
Forex summary.doc (45.0 KB)
Prasanna Gaddam (BOB member since 2013-03-21)
Hi Prasanna,
You probably already have this figured out however, for reference listed below is what I did.
Set the Filter in the QAAWS to Matches Pattern then select Prompt. On the “Define a Prompt” dialog box check Set the default value(s) of the Prompt. Enter % in Type of Value: and click the > button to move it to Selected Values.
In Xcelsius use a “%” in the cell the QAAWS is reading. For an example, I use a List box to show ALL, QTR1, QTR2 etc. When the user clicks on ALL an if statement is used to convert it to a “%” (=IF(A1=“ALL”,"%",A1)).
wpepper (BOB member since 2009-04-01)