Slider Work around

[#1]

Hi Champs,

In a slider component, am using Revenue Field. User can select the range between the revenue say  1,000 to 100,000 and see the list of companies falling between the selected range.

Looks like slider component works with only numbers. My requirement is to show up the values as $5 Million, $10 Million until $1 Billion respectively morever as text think so its easyfor the user to understand.

CAn anyone please help me on this?

Thanks & Regards,

Praveen Palle

[swuehl]

No, a slider also works with discrete non-numerical values.

Create a data island table with your values and use this field in your slider component for selection.

[#3]

Hi Praveen,

You can format the number within properties like this :

so that, for instance a value of 10 will show as "$10 Million". You may have to add a new field in the load script as, for example revenue/1000000 and use the new field in the slider.

John

[#4]

Hi Swuehl,

Can you please elaborate and explain me on this as am very new to QlikView?

Thanks &Regards,

Praveen

[#5]

I hav added a new field in the load script saying Revenue/1000000 and used it in the slider and formateed accordingly.

But, I see the numbers as $0 Million, $.5e+003 Million,$1e+004 Million,$1.5e+004 Million.....so on

and I also need to show Millions and billions respectively.

Please suggest.

Thanks,

Praveen

[swuehl]

Here is a demo of what I was talking about ( a data island with discrete values to select from and a field event action in document properties to select revenue values according to the selected range).

[#7]

Hi Praveen,

You are correct to convert into Million, just try convert into number using num() function and keep declare decimal values.

num(Revenue/1000000,##.00)

Regds.

Raju