topic Re: Bucket with alphanumeric... in QlikView

Bucket with alphanumeric...

sibideepak — Wed, 24 Sep 2014 12:34:35 GMT

GEID	Level
155058	C14
234708	C16
257645	C15
307479	C15
430422	C15
435929	C16
815579	A05
818027	A05

in this data i want to create bucket with Level..

the range to character ie) A will one bucket , C will be another bucket ...it should be dynamic not only for A and C..

and measure is count(GEID)...and one bar should display combined data of all.

Re: Bucket with alphanumeric...

Anonymous — Wed, 24 Sep 2014 12:38:08 GMT

In your load script add a line like this :

left(Level,1) as Bucket ,

Re: Bucket with alphanumeric...

datanibbler — Wed, 24 Sep 2014 12:39:46 GMT

Hii Deepak,

you can try splitting it with the LEFT() and RIGHT() functions (into C and 14 and the like) and then put both those expressions inside a DUAL() function.

That way, you'll have both the letter and the number in one field and you can sort by (or bucket by) whatever you like.

HTH

Best regards,

DataNibbler

Re: Bucket with alphanumeric...

rubenmarin — Wed, 24 Sep 2014 12:41:06 GMT

Hi Deepak,

Not sure if I understand it well...You can use

Left(Level, 1) as Bucket

PurgeChar(Level, 1234567890) as Bucket