Excel Data Assistance! (Loading in User Excel Data into QlikView and how to make sense of it!)
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?