topic Re: Slider Work around in QlikView

Slider Work around

Fri, 03 Jan 2014 12:47:54 GMT

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

Re: Slider Work around

swuehl — Fri, 03 Jan 2014 13:05:34 GMT

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.

Re: Slider Work around

Fri, 03 Jan 2014 13:12:06 GMT

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

Re: Slider Work around

Mon, 06 Jan 2014 06:20:08 GMT

Hi Swuehl,

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

Thanks &Regards,

Praveen

Re: Slider Work around

Mon, 06 Jan 2014 06:24:41 GMT

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

Re: Re: Slider Work around

swuehl — Mon, 06 Jan 2014 12:21:25 GMT

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).

Re: Slider Work around

Mon, 06 Jan 2014 12:53:14 GMT

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