topic How to create user defined Range or Buckets ? in QlikView

How to create user defined Range or Buckets ?

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to create user defined Range or Buckets ?

shekhar_analyti — Mon, 22 Jan 2018 09:01:31 GMT

loveisfail‌

Re: How to create user defined Range or Buckets ?

Siva_Sankar — Mon, 22 Jan 2018 09:27:23 GMT

Hi Shekar,

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

Interval Match Feature/Function

-Siva

Re: How to create user defined Range or Buckets ?

shekhar_analyti — Mon, 22 Jan 2018 09:39:25 GMT

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 ..

Re: How to create user defined Range or Buckets ?

sasikanth — Mon, 22 Jan 2018 10:29:18 GMT

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

Re: How to create user defined Range or Buckets ?

shekhar_analyti — Mon, 22 Jan 2018 10:31:50 GMT

Hi All ,

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

Re: How to create user defined Range or Buckets ?

shekhar_analyti — Mon, 22 Jan 2018 10:35:30 GMT

Can you suggest me a best case for this

Re: How to create user defined Range or Buckets ?

shekhar_analyti — Mon, 22 Jan 2018 10:44:39 GMT

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

Re: How to create user defined Range or Buckets ?

sasikanth — Mon, 22 Jan 2018 10:57:13 GMT

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

why without extension ?

Re: How to create user defined Range or Buckets ?

stabben23 — Mon, 22 Jan 2018 11:05:45 GMT

Hi,

try if this solve Your requirement.