topic Re: loading data from huge excel file in QlikView

loading data from huge excel file

Thu, 19 Sep 2013 08:48:44 GMT

Hi,

I have three excel sheets in one excel workbook. Those are excel_A,excel_B,excel_C. excel_A contains 64,999 rows and excel_B contains 64,999 rows and excel_C contains 2830 rows. all sheets contains same column names. at first I tried to create a chart item by using excel_A but it is showing all blank values. could anyone help me how to get this data in straight table please.

Thanks.

Re: loading data from huge excel file

Thu, 19 Sep 2013 08:51:44 GMT

Could you post a sample small data & the expressions you are using to create your chart?

Re: loading data from huge excel file

Thu, 19 Sep 2013 09:01:40 GMT

send ur excel work book with some sample data

Re: loading data from huge excel file

Thu, 19 Sep 2013 10:19:09 GMT

Hi,

please see the attached that is sample data and in all three sheets it is same columns

Re: loading data from huge excel file

Thu, 19 Sep 2013 10:21:06 GMT

Hi,

please see the attached that is sample data and in all three sheets it is same columns

Re: Re: loading data from huge excel file

Thu, 19 Sep 2013 10:53:15 GMT

Hi Amelia,

You can pull the data & create a straight table. I have done for one sheet, yu can do the same for all 3 sheets and change the column name if you don't want them to join. PFA

To remove blank values,uncheck these options from presentation tab, refer to below screenshot:

Hope this helps!

Re: loading data from huge excel file

Thu, 19 Sep 2013 15:27:51 GMT

Hi,

Thanks very much and it's working. and I did for remaing sheets and I used Join so all the data appears in one straight table. But when I am trying to send Excel it's not responding. Could you let me know is there any way to send excel like sheet by sheet i,e first sheet contains 64,999 and second,third so on.

once again Thanks fo your help.

Re: loading data from huge excel file

Thu, 19 Sep 2013 15:58:22 GMT

I got it and can able to send to one sheet thanks for your help.