Slider Scenario

[#1]

I have a scenario. Please see the attached file.

Thank you.

[#2]

Hi,

Requirement 1

To sort the value, use the tab sort and put in expression

fabs(stock) descending

Requirement 2

i'm not sure to understand your need

best regards

chris

[#3]

Hi Chris,

I don't see the Stock field in the sort tab.

For requirement please find the updated excel attached

[#4]

Corrections on the sort tab (Req1). I see the field but the check box to use the expression option is not enabled.

[#5]

Can you upload the qvw please ?

chris

[jerem1234]

Create a Straight Table, with Dimension of MarketCategory. Use this expression:

=if(fabs(SUM(QtyOrdered -QtySold))>vSlider,SUM(QtyOrdered -QtySold))

Under sort click on Expression for MarketCategory, and enter this in:

fabs(SUM(QtyOrdered -QtySold))

with Descending.

Then create slider with the variable vSlider, with min value of 0, max value of 5, and static step of 1.

Hope this helps!

[#7]

I still get the records with NULLs where the slider is ignoring. Just that stock is "-".

I need to drop those records from the list.

[jerem1234]

Check Suppress Zero-Values on your presentation tab on your straight table. Since your minimum on your slider is zero, the zero values won't show anyway. Unless you still want the zeros to show???