Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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 ?
google like Custom Slider object Qlikview
So sorry if i didn't show correct way.
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
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.