Discussion board where members can get started with QlikView.
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.
and I need something like
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