topic Re: Problem with export excel from Qlikvie in QlikView

Problem with export excel from Qlikvie

Tue, 30 May 2017 15:15:10 GMT

Hi all

I link my report excel from qlikview but i can see the right way if anyone can help me.

The file executes like this when downloading the excel from the Qlikview

Re: Problem with export excel from Qlikvie

prieper — Tue, 30 May 2017 15:33:12 GMT

Read the table with header line, first row as embedded labels:

Peter

Re: Problem with export excel from Qlikvie

Tue, 30 May 2017 15:40:22 GMT

this is option in qlik or in excel?

Re: Problem with export excel from Qlikvie

el_aprendiz111 — Tue, 30 May 2017 15:41:34 GMT

Hi:

Fron Excel
Text To Columns
Deliminted
semicolon

Are many rows and generates it as CSV

Re: Problem with export excel from Qlikvie

prieper — Tue, 30 May 2017 16:19:46 GMT

Sorry,

misunderstood your question. My suggestion was basing on Import to QlikView (with settings in QV-wizard).

Think that Fer Fer is correct. This is an export as csv.

Is there a chance to change the header-names without using two rows?

Re: Problem with export excel from Qlikvie

Tue, 30 May 2017 19:04:36 GMT

Still got the same problem when im download my report from QlikView to excel still open the same in picture when was to so small im got this problem like few days ago

Re: Problem with export excel from Qlikvie

el_aprendiz111 — Tue, 30 May 2017 19:38:41 GMT

Hi Jose

You can send a sample of your App

Re: Problem with export excel from Qlikvie

kamal_sanguri — Wed, 31 May 2017 07:20:40 GMT

Can you try below method.

Step 1:

Qlikview

Right click on table -> Copy table to clipboard -> Full table

Step 2:

Excel

Right click ->Paste Special -> Text

Re: Problem with export excel from Qlikvie

Wed, 31 May 2017 17:20:27 GMT

sample are in the first post

Re: Problem with export excel from Qlikvie

kamal_sanguri — Thu, 01 Jun 2017 05:14:50 GMT

I strongly advise you to revisit your data, The problem is with your data.

In case of delimited data when open in Excel all the data must be there in First column. However, I see that there is data in Second Column (Starting from Line No. 20), Third Column (Starting from Line No. 30), Forth, Fifth, Sixth & Seventh Column (at Line No. 518).

Re: Problem with export excel from Qlikvie

kamal_sanguri — Thu, 01 Jun 2017 07:19:56 GMT

The other reason could be you are not loading data correctly. Please do a Ctrl + T after loading data and see how many columns are there.

If you see only one column then, you are not delimiting the data while loading.

Pls. follow below steps -

Select the Semicolon as Delimiter while loading data in Qlikview. The data in one column then be distributed to different column.