How to create user defined Range or Buckets ?

[shekhar_analyti]

Hi All ,

Client	Product	Sub_Product	Legend	Value	Rank
Accra-Pac, Inc.	Torsemide	levothyroxine sodium	Latency	58	1
ALK-Abello, Inc.	Anastrozole	Anastrozole	Accuracy	58	8
AuroMedics Pharma LLC	Head and Shoulders	Pyrithione Zinc	Accuracy	54	4
AvKARE, Inc.	Anastrozole	rotigotine	Accuracy	54	2
Bath & Body Works, Inc.	Ampicillin	BUPIVACAINE HYDROCHLORIDE	Accuracy	51	2
Bolero Home Decor, Inc.	Torsemide	Torsemide	Accuracy	60	8
Cadila Healthcare Limited	Gemfibrozil	Gemfibrozil	Accuracy	58	8
Cardinal Health	Match Perfection SPF 20	Alcohol	Accuracy	55	5
Cardinal Health	Phentermine Hydrochloride	Phentermine Hydrochloride	Latency	51	3

With above sample data i want to create three bucket to show below in chart

Count of Client whose Rank fall between

1) X - Y (Bucket 1)

2) A - B  (Bucket 2)

3) C - D  (Bucket 3)

Basically end user should be able to assign or decide value of A,Y ; A,B ; C,D ...

Ex - If user feels that in bucket 1 he/she should see the count of client with rank having 1 to 3 , then UI should have option to let select 1 and 3 , and for bucket 2 all the rank value from 4 to 6 , similarly for bucket 3 rank value from 6 to 9

I am not sure how to achieve this . Data is attached as well .

Thanks & Regards

Shekar

[shekhar_analyti]

loveisfail‌

[Siva_Sankar]

Hi Shekar,

You can use interval match for this purpose. Find my step by step document on this.

Interval Match Feature/Function

-Siva

[shekhar_analyti]

Hi Siva ,

Thanks for reply  .
Can you please suggest me way to have three Bucket using Interval match . Because i am not sure how to get it ..

[sasikanth · Accepted solution]

HI shekar,

you can achieve this using Variables & Input box

create two variable & 2 input boxes for every bucket

Ex:  Var1Min ,Var1Max

and use below exp to define range in a calculated Dimension

If( Rank >=$(Var1Min) and Rank<=$(Var1Max) ,"Bucket1",

     IF(Rank >=$(Var2Min) and Rank<=$(Var2Max) ,"Bucket1",    

              IF(Rank >=$(Var3Min) and Rank<=$(Var3Max) ,"Bucket1")))

Not a best one but still you can use

[shekhar_analyti]

Hi All ,

I solved it using input box .. Any other suggestion is highly welcomed !!

[shekhar_analyti]

Can you suggest me a best case for this

[shekhar_analyti]

Can you suggest me way to achieve in Qliksense with No extension ..

[sasikanth]

I don`t think we can achieve the same with out a input box extension in Sense,

why without extension ?

[stabben23]

Hi,

try if this solve Your requirement.