Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a scenario. Please see the attached file.
Thank you.
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
Hi Chris,
I don't see the Stock field in the sort tab.
For requirement please find the updated excel attached
Corrections on the sort tab (Req1). I see the field but the check box to use the expression option is not enabled.
Can you upload the qvw please ?
chris
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!
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.
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???