Excel Data Assistance! (Loading in User Excel Data into QlikView and how to make sense of it!)

[Dayna]

Dear All,

I really hope you can help me, please find attached an example of user data that I need to inport into QlikView and make it useful. What I need to do, is other than make it useful in QlikView, is to consolidate all the timescales so there selectable, make the sub catagory under the timescale (MU, SU, Sales, CTBN) into Selectors and to remove the total's (obviously there's more customers, but this is one example). So in the excel sheet, each has a total at the end which I don't want to display.

Now, obviously due to the size of the sheet I can't rewrite the excel document, but is there anything I can do within QlikView?

You're help is always appreciated!!

Kind Regards,
Dayna

[dirk_konings]

something like this ??

[Dayna]

many thanks, nearly - all the MU, SU, etc need to be one selector, as it's the same category... I also need the date range specified at the top to be a selector and related to the data.

Any ideas??

[Dayna]

Hey, can anyone help me with the above?

Many thanks!
Dayna