topic Re: Issue while loading from Excel File...? in QlikView

Issue while loading from Excel File...?

vishalgoud — Thu, 25 Jun 2015 06:27:41 GMT

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

Re: Issue while loading from Excel File...?

jsingh71 — Thu, 25 Jun 2015 06:31:19 GMT

Hi Vishal,

Can you please upload a sample excel sheet.

Re: Issue while loading from Excel File...?

MK_QSL — Thu, 25 Jun 2015 06:32:03 GMT

Can you provide some sample data in excel file please?

Re: Issue while loading from Excel File...?

jonathandienst — Thu, 25 Jun 2015 06:40:15 GMT

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.

Re: Issue while loading from Excel File...?

vishalgoud — Thu, 25 Jun 2015 10:04:27 GMT

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.

Re: Issue while loading from Excel File...?

vishalgoud — Thu, 25 Jun 2015 10:07:25 GMT

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..