topic Re: Set Analysis to Group Records in QlikView

Set Analysis to Group Records

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

I have below records in a table

Name	Department	job
Name1	Dep A	job1
Name2	Dep A	job1
Name2	DepB	Job1
Name3	DepB	job2
Name3	DepB	job2

I want group the names based on department,

Names Dep A only, Names Dep B only, Names both departments in three straight tables.

Re: Set Analysis to Group Records

sunny_talwar — Tue, 31 May 2016 09:53:27 GMT

Not sure I understand the output you are looking to get. Would you be able to elaborate on the kind of output you need?

UPDATE: May be this:

Straight Table A uses

{<Department = {'Dep A'}>}

Straight Table B uses

{<Department = {'DepB'}>}

Straight Table C uses no set analysis or

{<Department = {'Dep A', 'DepB}>}

Re: Set Analysis to Group Records

anuradhaa — Tue, 31 May 2016 09:57:23 GMT

In Tables 1

Name only DEp A

-------------------------------

Name1

In Tables 2

Names only DEP B

--------------------------------

Name2

In Tables3

Names both Deps

-----------------------------

Name3

Re: Set Analysis to Group Records

sunny_talwar — Tue, 31 May 2016 09:59:20 GMT

What is the expression you are using? Add the set analysis I have provided above for each of the table

Re: Set Analysis to Group Records

anuradhaa — Tue, 31 May 2016 09:59:47 GMT

I needs Name and job in Straight Table.

Where should i put that set analysis expression?

Re: Set Analysis to Group Records

anuradhaa — Tue, 31 May 2016 10:01:51 GMT

I dn't want to do any calculations. i need a table with Name and Job

Re: Set Analysis to Group Records

sunny_talwar — Tue, 31 May 2016 10:03:15 GMT

I guess you can add Name as your dimension and following expressions:

1) Only({<Department = {'Dep A'}>} job)

2) Only({<Department = {'DepB'}>} job)

3) Only({<Department = {'Dep A', 'DeptB}>} job)

Re: Set Analysis to Group Records

Kushal_Chawda — Tue, 31 May 2016 10:07:53 GMT

Just create single the Table like below, I am not sure why you need 3 tables here

Dimension:

Name

Department

Job

Expression:

Your Expression

Simply create the list box for Department and select the Department you want and see the result in Single straight table instead of 3 tables

Re: Set Analysis to Group Records

Anonymous — Tue, 31 May 2016 10:13:00 GMT

Hi Anuradha,

For Dept A:

Aggr(MaxString({<Name = {$(=Count({<Department = {'Dep A'}>} Name)>0)}>} Name),Name)

For Dept B:

Aggr(MaxString({<Name = {$(=Count({<Department = {'Dep A'}>} Name)>0)}>} Name),Name)

For Both:

Aggr(MaxString({<Name = {$(=Count({<Department = {'Dep A','Dep B'}>} Name)>0)}>} Name),Name)

Kind Regards,

Re: Set Analysis to Group Records

anuradhaa — Tue, 31 May 2016 10:24:22 GMT

it's not working, can you please share a sample

Re: Set Analysis to Group Records

sunny_talwar — Tue, 31 May 2016 10:28:58 GMT

Try the attached

Re: Set Analysis to Group Records

anuradhaa — Tue, 31 May 2016 10:32:58 GMT

Here what i want is display the Name with is assign only to the Dep A,

So It needs to have only one record (Name1)

Is it possible to do so?

Re: Set Analysis to Group Records

sunny_talwar — Tue, 31 May 2016 10:36:04 GMT

May be like this:

1) {<Name = e({<Department = {'DepB'}>})>}

2) {<Name = e({<Department = {'Dep A'}>})>}

Re: Set Analysis to Group Records

sasiparupudi1 — Tue, 31 May 2016 10:42:39 GMT

Please see the attachment

hth

Sasi