What is meant by Interactive in document?
If you are looking for conditional dimensions? -- See attached.
test.qvw 154.5 K
That would be easy....there are two options
Option 1: //Works in version QV 11 onwards
Since you cant open the atached, follow below steps...
Script: copy this into your script
load * inline [
Branch,Account,suffix ,Currency ,Balance
//This is just a inlne table to hide and display the dimensions in the chart..
Load * Inline [
1. Add "Dims" as list box.
2. Create a chart and add all the available dimensions from the data table.
3. On each dimension add the conditional statemets to show or hide the Dims.
a. for Branch = SubStringCount(Concat(Dims, '|'), 'Branch')
b. for Account =SubStringCount(Concat(Dims, '|'), 'Account')...and so on
4. Add the expresssion sum(Balance)
5. Try choosing Dims from the list box...Woola you have a Sum(Balance) grouped by the dimensions you choose...no need to go back to the script..
Option 1: //Works in any QV version
As Mooorthy Said below...you can use a Pivot table..
Just add all the dimensions and expressions you need to the Pivot table.
Pivot table allows you to "expand" and collapse the dimensions...
Hope you will solve your problem...