Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
MVP
MVP

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.