Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
lionking15
Creator
Creator

Slider

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

4 Replies
Anonymous
Not applicable

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

ramasaisaksoft

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.

rahulpawarb
Specialist III
Specialist III

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

Slider.PNG

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

surendraj
Specialist
Specialist

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

1.png

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