Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ncarson3
Contributor III
Contributor III

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

0 Replies