topic Re: How to group 2 columns into 1??? in QlikView

How to group 2 columns into 1???

jsingh71 — Thu, 22 Nov 2012 10:53:20 GMT

I have a table like this

Planned	Holiday	Vacation
6	1	5
10	3	7
20	6	14
7	2	5
11	3	8
22	7	15
8	3	5
18	6	12

Now I want to Group 'Holiday' and 'Vacation' Under 'Planned'

Re: How to group 2 columns into 1???

Thu, 22 Nov 2012 10:58:58 GMT

Didn't get your question.

Can ypu please elaborate what is it that you are trying to accomplish

Regards

Mhatim

Re: How to group 2 columns into 1???

its_anandrjs — Thu, 22 Nov 2012 11:05:31 GMT

In a load script create a field like

Holiday+Vacation as NewPlanned

But what is requirement for this and meaning of Group 'Holiday' and 'Vacation' Under 'Planned'

Regards,

Anand

Re: How to group 2 columns into 1???

jagannalla — Thu, 22 Nov 2012 11:06:45 GMT

Hello,

Try this:

Main:
Load RowNo() as Key,
Planned as P,
Holiday as H,
Vacation as V
From Main.qvd;
Res_Main:
Load Key, P as Planned Resident Main;
Load Key, H as Planned Resident Main;
Load Key, V as Planned Resident Main;

Hope it helps you..

Cheers!!

Jagan

Re: How to group 2 columns into 1???

jagan — Fri, 23 Nov 2012 09:50:34 GMT

Hi,

Try this script

TableName:

Load

Planned AS Dimension,

'Planned' AS Type

FROM DataSource;

Concatenate(TableName)

Load

Holiday AS Dimension,

'Holiday' AS Type

FROM DataSource;

Concatenate(TableName)

Load

Vacation AS Dimension,

'Vacation' AS Type

FROM DataSource;

Hope this helps you.

Regards,

Jagan.