Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ncarson3
New Contributor II

Crosstable/For loop Question

Hi everyone, I have a big table consisting of multiple header items that i need to consolidate by months. I know I can do this in several ways, but my code is long and manual and I was hoping one of the geniuses here could help me learn a better way.

My table has the following fields.

ID

Name

Title

SalesAug

SalesSep

SalesOct

SalesNov

SalesDec

SalesJan
SalesFeb

SalesMar

SalesMay

SalesJun

SalesJul

HoursAug

HoursSep

HoursOct

HoursNov

HoursDec

HoursJan
HoursFeb

HoursMar

HoursMay

HoursJun

HoursJul

BonusAug

BonusSep

BonusOct

BonusNov

BonusDec

BonusJan
BonusFeb

BonusMar

BonusMay

BonusJun

BonusJul

Is there a clean way I can make this into a table with the following fields:

ID

Name

Title

Month

Sales

Hours

Bonus

Any help is appreciated

Tags (2)