Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Dayna
Creator
Creator

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

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

3 Replies
dirk_konings
Creator III
Creator III

something like this ??

Dayna
Creator
Creator
Author

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
Creator
Creator
Author

Hey, can anyone help me with the above?

Many thanks!
Dayna