topic Re: Using Full Accumulation with variable in QlikView

Using Full Accumulation with variable

zagzebski — Sat, 27 Jul 2013 17:29:32 GMT

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.

Re: Using Full Accumulation with variable

swuehl — Sun, 28 Jul 2013 14:14:27 GMT

You should get what you want using a slider with a variable and Dimension Limits in chart properties.

Check attached sample.

Re: Using Full Accumulation with variable

zagzebski — Sun, 28 Jul 2013 18:52:56 GMT

Awesome, thanks so much!

We have been using V10 so long I didn't even look into the Dimension Limits.

Steve

Re: Using Full Accumulation with variable

paulyeo11 — Sun, 28 Jul 2013 21:12:03 GMT

Hi Sir

when i change the silde % from 0 to 100% , the 2 table does not change , do i miss out any thing ?

Paul

Re: Using Full Accumulation with variable

swuehl — Sun, 28 Jul 2013 22:16:55 GMT

Paul,

I am using dimension limits. What version of QV are you using?

Re: Using Full Accumulation with variable

paulyeo11 — Sun, 28 Jul 2013 22:23:57 GMT

I am still 9

Sent from Samsung Mobile

Re: Using Full Accumulation with variable

zagzebski — Wed, 31 Jul 2013 00:48:10 GMT

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