Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalgoud
Creator III
Creator III

Issue while loading from Excel File...?

Hi Experts,

I have an Excel File Which Contains  Different categorizes in one sheet  for the year 2015 and Each category is different from other.

categories cells are in BOLD format...

attaching the Jan sample data below , PFA ..Attached data is just for January month we have Complete year data..

Each category is having different data ( different rows )..

now i want to load all the categories data and if i select year 2015 it has to display all the categories , and if i select any category it has to show all the its related values...

here the problem is all the categories are present in only one sheet..while loading the data we are getting different fields which are not Expected...

tried with cross table method but no result, any other method to load these different categories in one table..

or whether we need to change the Excel format...?

Please find the below excel sheet and let me know your possible solutions on this..

Thanks in Advance...

Best Regards

Vishal

5 Replies
jsingh71
Partner - Specialist
Partner - Specialist

Hi Vishal,

Can you please upload a sample excel sheet.

MK_QSL
MVP
MVP

Can you provide some sample data in excel file please?

jonathandienst
Partner - Champion III
Partner - Champion III

vishal goud wrote:

now i want to load each category as a separate table

May I ask you why you want load these in separate tables? This will result in a data model that if difficult to report from and may give incorrect results due to the synthetic keys that will be produced. This is not an optimal model design from QV and it may be possible to deliver what you need without such an awkward data model.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
vishalgoud
Creator III
Creator III
Author

Please find the Attached sample file which contains 6 categories (dark cells),

I want to load Category wise data and  data should be separate for Each category , I don't want to load each category as Separate Table as it Create Synthetic Keys...

Thanks in Advance..

Regards

Vishal.

vishalgoud
Creator III
Creator III
Author

Hi Jonathan,

Thank very much for your  suggestion. please find the Above attachment and try to provide the alternate solution for this issue.

Regards

Vishal..