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

Group Certain Fields in Table into 1 Field within the table

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

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.

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

sunny_talwar — Thu, 06 Jun 2019 16:23:10 GMT

Have you looked at this? The Crosstable Load

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

wonkymeister — Mon, 10 Jun 2019 14:32:35 GMT

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

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

sunny_talwar — Mon, 10 Jun 2019 14:40:17 GMT

Why not?

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

andrei_delta — Tue, 11 Jun 2019 09:40:17 GMT

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!