topic Re: Creating a table with range in QlikView

Creating a table with range

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

Hi ,

How to create a table with range as shown below.

The salary range is given as Range and no.of boys and girls salary based on slab.

Can someone help me out how to create the table.

Thanks,

Vijaya

Re: Creating a table with range

devarasu07 — Wed, 06 Dec 2017 09:16:36 GMT

Hi,

Can you share your mock data. thanks

P.S: you can try to create calculated dimension in back/front end like attached article

Buckets

Re: Creating a table with range

Anil_Babu_Samineni — Wed, 06 Dec 2017 09:21:09 GMT

If you have field called Gender with field values like Boys and Girls. Perhaps like below?

If(Range >= 0 and Range <= 1000, Dual('0 to $1K',1),

If(Range >= 1000 and Range <= 50000, Dual('$1K to $50K',2), Dual('> $ 50K', 3))) as Range_Dim

Dimension as Range_Dim

And Formulas should be

1) % of Boys -- Avg({<Gender = {'Boys'}>} Measure)

2) # of Boys -- Count({<Gender = {'Boys'}>} FieldName)

3) % of Girls -- Avg({<Gender = {'Girls'}>} Measure)

4) # of Girls -- Count({<Gender = {'Girls'}>} FieldName)

Re: Creating a table with range

kvr9 — Thu, 07 Dec 2017 10:43:29 GMT

Hi ,

Please the sample data and qvd.

Can you please tell me how to get the negative values in the range.

Re: Creating a table with range

Anil_Babu_Samineni — Thu, 07 Dec 2017 12:43:05 GMT

PFA

Re: Creating a table with range

kvr9 — Fri, 08 Dec 2017 07:58:55 GMT

Hi Anil,

Thank you for your help.

Did we use the same calculation or Salary_Dim Column??

Also I have observed the negative values are falling under the range >$50.

Re: Creating a table with range

Anil_Babu_Samineni — Fri, 08 Dec 2017 08:46:25 GMT

Yes, we can use. May be the reason we are calculating 0-1000, 1000-50k and >50k. That means, We are not calculating Negative now. For now, You can remove >0 and use directly like

If(Salary<1000, '<$1k')