Discussion board where members can get started with Qlik Sense.
I have Field called Bucket which is contain values like 1 to 10000
I want to make it as 1 to 999 as 1stBucket
1k to 2.9k as 2nd Bucket
3k to 5k as 3rd Bucket
I want to display like above. Can anyone help me to get above
I would probably do this with an IF statement in the script unless you want exact intervals. Then you can use the Class Function - https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/ConditionalFunctions/cla...
LOAD * INLINE [
IF(Value <= 250,'1st Bucket',
IF(Value <= 500,'2nd Bucket',
'3rd Bucket')) AS Buckets
// Above you can define how you want them to be divided in the IF Statement.
Drop Table Temp;
Gives you this:
what's your expected output ?
Create like this in script or chart:
IF(Bucket >= 1 and Bucket < 999, '1st Bucket',
IF(Bucket >= 1000 and Bucket < 2999, '2nd Bucket',
IF(Bucket >= 3000 and Bucket < 5000, '3rd Bucket',
'4th Bucket'))) as Bucket
Now create a chart
Have a look