topic Re: Slider in QlikView

Slider

lionking15 — Wed, 25 Nov 2020 16:16:04 GMT

HI,

I want to create SLIDER with unequal data set,

i.e-Range

<10k

10k to 50k

50k 10 1lakh

1lakh to 10lakh

more than 10lakh

Re: Slider

Anonymous — Wed, 25 Jan 2017 05:42:28 GMT

Hi Giridhar,

You can refer following link for detailed information about slider.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Slider_Object.htm

else simply you can select slider from new sheet object and take range as field.

Thanks,

Pooja Singh

Re: Slider

ramasaisaksoft — Wed, 25 Jan 2017 06:50:51 GMT

Hi Giri,

Note:- I don't have licensed version so i am unable to see these attached qvw's so please check by ur self.

Custom MonthYear range in a slider! How to do it ?

Custom Time Buckets

google like Custom Slider object Qlikview

So sorry if i didn't show correct way.

Re: Slider

rahulpawarb — Wed, 25 Jan 2017 07:29:27 GMT

Hello Giridhar,

Trust that you are doing good!

You can opt for below solution:

1. Define a bucket table with range values of your choice (It includes: Band for unique identification of range, Range start point, Range end point and Range Description).

Bucket:
LOAD * INLINE [
Band, Start, End, Range
1, 0, 9999, < 10k
2, 10000, 49000, 10 k to < 50k
3, 50000, 99999, 50 k to < 1 lakh
4, 100000, 999999, 1 lakh to < 10 lakh
5, 1000000, , More than or equal to 10 lakh
];

2. Load data from source file and populate Band field value referring Bucket table.

Sales:
LOAD [Customer Name],
    Sales,
    If(Sales>=1000000, 5, If(Sales>=100000, 4, If(Sales>=50000, 3,  If(Sales>=10000, 2, 1)))) AS Band
FROM
SampleData.xls
(biff, embedded labels, table is Sales$);

3. Reload the script

4. Add Slider/Calendar Object and select properties as below:

Input Style = Slider

Value Mode = Discrete

5. Once this is done then you are ready to do your analysis.

I have attached the sample application herewith. Let me know if you any queries.

Thank you!

Rahul

Re: Slider

surendraj — Wed, 25 Jan 2017 07:29:55 GMT

R u looking for!!

LOAD * INLINE [

range

1000

10000

50000

100000

1000000

10000000

];

Right click-->new sheet object-->Slider/Calnder object--->input style(slider)--->field as Range

Sorry if i am not suggested the way you looking for.