Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
wonkymeister
Contributor

Group Certain Fields in Table into 1 Field within the table

Hi,

I have a single table of finance data that contains multiple fields and for display purposes I’d like to group 6 of the fields from the table into 1 single field in order that I can display the 6 fields in one table as 1 dimension with an additional column as actuals(the expression).

I.e.

Finance_Table:

Actual,

Budget,

Group1_code,

Group2_code,

Group3_code,

Field1_to_combine,

Field2_to_combine,

Field3_to_combine,

Field4_to_combine,

Field5_to_combine,

Field6_to_combine,

Financial_year,

Financial_period,

Etc

how can i logically group Field1_to_combine, Field2_to_combine, Field3_to_combine, Field4_to_combine, Field5_to_combine, Field6_to_combine into 1 field in the table? I thought of concatenating them as a resident load? Some way to remodel the fields in the load script?

any ideas/thoughts greatly appreciated.

 

4 Replies
Highlighted

Re: Group Certain Fields in Table into 1 Field within the table

Have you looked at this? The Crosstable Load

Highlighted
wonkymeister
Contributor

Re: Group Certain Fields in Table into 1 Field within the table

thanks but i dont think the cross table function will do what i need. 

Highlighted

Re: Group Certain Fields in Table into 1 Field within the table

Why not?

Highlighted
Partner
Partner

Re: Group Certain Fields in Table into 1 Field within the table

hi,

example for group_code:

if ( len(Group1_code)>0,

              Group1_code,

              if( len(Group2_code)>0,

                            Group2_code,

                             if(len(Group3_code)>0,Group3_code))) as GroupCode

concatenate it's an alternative but i wouldn't use it in your case.

hope it helps!