Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jsingh71
Partner
Partner

How to group 2 columns into 1???

I have a table like this

PlannedHolidayVacation
615
1037
20614
725
1138
22715
835
18612

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

4 Replies
Not applicable

Didn't get your question.

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

Regards

Mhatim

its_anandrjs

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

jagannalla
Partner
Partner

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

jagan
Luminary Alumni
Luminary Alumni

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.