topic Slider Scenario in QlikView

Slider Scenario

Thu, 14 Nov 2013 15:34:22 GMT

I have a scenario. Please see the attached file.

Thank you.

Re: Slider Scenario

Thu, 14 Nov 2013 15:41:40 GMT

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

Re: Re: Slider Scenario

Thu, 14 Nov 2013 15:47:54 GMT

Hi Chris,

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

For requirement please find the updated excel attached

Re: Re: Slider Scenario

Thu, 14 Nov 2013 15:54:07 GMT

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

Re: Slider Scenario

Thu, 14 Nov 2013 16:00:48 GMT

Can you upload the qvw please ?

chris

Re: Slider Scenario

jerem1234 — Thu, 14 Nov 2013 17:36:36 GMT

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!

Re: Slider Scenario

Thu, 14 Nov 2013 18:49:29 GMT

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.

Re: Slider Scenario

jerem1234 — Thu, 14 Nov 2013 18:55:52 GMT

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???