topic Re: Company and number aligned, and employee intervals in QlikView

Company and number aligned, and employee intervals

Thu, 07 Nov 2013 23:21:05 GMT

1) I have this simpel customer table with company name and phone number as seperate fields, at this specific level I need to link company name with the exact phone number, without clicking on a single company!? This mean that from the list of companies the list of phone numbers are aligned. I dont want to merge the fields from the original datasource.

2) I have a field with number of employees (Company size), and I would like to sort/group the rows into intervals!?

Plz

Re: Company and number aligned, and employee intervals

Sat, 09 Nov 2013 12:04:16 GMT

CAn you attach The table?

Re: Company and number aligned, and employee intervals

swuehl — Sat, 09 Nov 2013 12:20:30 GMT

1) If you have a table like this

Company, PhoneNumber

Company A, 12345678

Company B, 23456789

it should be as simple as creating a straight table chart with dimension Company and as expression use

=only(PhoneNumber)

2) There are multiple ways to classify the company size, one way is to use the class() function:

LOAD *,

class(Size, 250) as CompanyClass

INLINE [

Company, Size

Company A, 100

Company B, 1000

Company C, 2500,

Company D, 200

];

Re: Company and number aligned, and employee intervals

Sat, 09 Nov 2013 14:38:50 GMT

Sorry data is confidential. It is just a simple table, from the Edit script window it looks like this (translated to English):

"...

SET DayNames='ma;ti;on;to;fr;lø;sø';

LOAD Company name,

Address,

Zip code,

City Name,

Phone number,

# Employees,

Segment,

FROM

(biff, embedded labels);

Re: Company and number aligned, and employee intervals

Sat, 09 Nov 2013 15:31:09 GMT

1) Well I don't understand why I should create a chart? Lets say I have the fields Company name, Phone number and Segment shown. So I click on a Segment, it becomes green and in the Company name section I might get 20 Companies marked white, properly the same for Phone number. The only problem is that I don't know which Company goes with which number unless I click on a specific company name or phone number. I want to have the Company list and the Phone list next to each other, or something similar, and be that company A and phone number A is next to each other.

2) I have the field # Employees which for instance could range from 30 to 3000. So I just need to consolidate them a bit, like 30-50, 50-100, etc., so I can click on a range and see how many companies I have in the range between 30-50.

Re: Company and number aligned, and employee intervals

swuehl — Sat, 09 Nov 2013 16:38:45 GMT

1) You can also create an expression in a list box for field Company. Expression would also be

=only(PhoneNumber)

=concat(PhoneNumber)

if you may have a 1:n relationship.

Creating a list box with an expression is not much different to a straight table chart, though (by default, a list box displays also excluded values).

2) As I said use a conditional expression to classify your data, either using class() function or maybe

LOAD NumEmployees,

if(NumEmployees < 30, '<30', if(NumEmployees <50, '30-50', if(NumEmployees < 100,'50-100','>=100'))) as Class,

...

Re: Company and number aligned, and employee intervals

Sat, 09 Nov 2013 20:22:50 GMT

Thx, I guess I misunderstood you then, sorry.

The list box work perfect in this case. Also I thought Classes was something else, but it works great