Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to be able to use a variable in tandem with a column that has cummulative reve % by product.
So I want to be able to use a slider that will show only the top ?% of revenue.
Example
Product Revenue Cummulative Rev%
A 100 10%
B 600 70%
C 300 100%
In the example above if the user move the slider (variable) to 15% only product A would show, if they moved it to 70% then A and B would show, and so on.
You should get what you want using a slider with a variable and Dimension Limits in chart properties.
Check attached sample.
You should get what you want using a slider with a variable and Dimension Limits in chart properties.
Check attached sample.
Awesome, thanks so much!
We have been using V10 so long I didn't even look into the Dimension Limits.
Steve
Hi Sir
when i change the silde % from 0 to 100% , the 2 table does not change , do i miss out any thing ?
Paul
Paul,
I am using dimension limits. What version of QV are you using?
I am still 9
Sent from Samsung Mobile
So I built the object with the dimnesion limit and it worked well, However is it possible to build the second object below based on the slider (variable choice in the dimension limit)
\
Source Data:
Product Region Revenue
A East 50
A West 50
B East 200
B North 300
B South 100
C South 300
Object 1: Selection 70% on the slider would show only A and B
Product Revenue Cummulative Rev%
A 100 10%
B 600 70%
C 300 100%
Object 2: How could I get a new object to respect the 70% selection (products) but show the Region they came from:
Region Revenue
East 250
West 50
North 300
South 100
Steve