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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.