Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Excel Import/Cross table

Hello

I have about 40 spreadsheets in the following format which I need to import.

I can write some VBA stuff but id like to do this in QV. I think Ill need some kind of Crosstable notion but Im not sure.

DescriptionAgeQ1SalesStaffQ2SalesStaffQ3Sales ... ...
Leeds24554323232343437676
London3446434545423237676

and I need something like

DescriptionAgeQuarterSalesStaff

Leeds

214554323
Leeds2223234343
Leeds237676
London31446434
London3254542323

The Q1/Q2 columns in my data were just sum(Sales+Staff) and so I dont need it.

I've tried various rotations and things and not got too far. Any ideas? Ideally something step by step

Attached is a skeleton of my data

Tags (3)
Community Browser