topic Re: creating a number band in QlikView

creating a number band

Fri, 20 Sep 2013 07:17:09 GMT

Hi, in my records I have a numeric field named 'SumInsured'.

What I need to do is to band all the records according to the SumInusured field.

Example, I need to have the following:

Any ideas on how I can go about this please?

Fri, 20 Sep 2013 07:35:16 GMT

Hi,

You can use AGGR function to get count of records according to SumInsured field. Might be something like this:

Aggr(Count(Cust_ID), SUMINSURED)

Here Cust_ID being the field which you want to count.

Hope this helps!

Fri, 20 Sep 2013 08:12:46 GMT

Hi Shyamal, what I need to know is how to allocate the SumInsured field to a Band

sujeetsingh — Fri, 20 Sep 2013 08:17:47 GMT

just create a new field in your script as

if(Sum(SUMINSURED)>0 and Sum(SUMINSURED)>100,'0-1000')

Hence you can use it in nested if expression or else just assign a value to it.

Fri, 20 Sep 2013 08:21:21 GMT

Hi,

You can use the class function if you have fixed intervals:

Class(SumInsured, 10000).

If you need to achieve that based on the sum by Cust_ID according to your current selections, you can do it like this:

Class(Aggr(Sum(SumInsured), Cust_ID), 10000)

Hope this will help you.

Fri, 20 Sep 2013 08:58:13 GMT

Hi Jean-Pierre, Class function seems to be what I am looking for. Do you add the class function in the script or in an expression?

AbhijitBansode — Fri, 20 Sep 2013 09:05:51 GMT

Use calculated dimension using Class function:

Class(SumInusured , 10000)

it will by default return ranges in format '<= x <'

you can use Replace function on top of it to get the required format:

Replace(Class(SumInusured , 10000), '<= x <', ' - ')

Fri, 20 Sep 2013 09:08:22 GMT

You can use this function also from the script.

But what I've suggested is to use it in your dimension, to be dynamically changed based on your selections.

basav — Mon, 06 Jan 2020 04:42:23 GMT

Class(Aggr(Sum(SumInsured), Cust_ID), 10000, '-'). Slight modification.