topic Re: 2 or more header in QlikView

2 or more header

Tue, 30 Jul 2013 06:32:15 GMT

Hi,

I have a excel file. It looks something like this as exemple

1 2 3 4 5 Column

Morning | Afternoon | Time

In Out | In Out |

8:00 12:00 | 12:30 16:00 | XXX

And in the List box it looks like this

[1] [2] [3] [4] [5] Listname

Morning Out Afternoon Out Time

In 12:00 In 16:00 XXX

8:00 12:30

I would like that it doesn't show the words just the times.

[1] [2] [3] [4] [5]

8:00 12:00 12:30 16:00 XXX

How can I do that?

Re: 2 or more header

Tue, 30 Jul 2013 07:44:26 GMT

Hansjörg,

please upload an example file.

Thank you.

Rainer

Re: 2 or more header

Tue, 30 Jul 2013 08:04:20 GMT

are you setting it up correctly when you add your excel to the import file? there should be a column names in first row button to tick which should fix your problem.

Re: 2 or more header

Wed, 31 Jul 2013 11:39:52 GMT

Thanks it was a problem in the setting by importing.

When you go to Import it the first window has the option on the right top "Header Size" there you can say i would like to have the first 4 linse as header and then he deletes it.

I also had the problem that i have some information at the end which are not needed. So at the second step you can click "Enable Transformation Step" there you mark the lines which we dont wont to see and push "Delete Marked".

I hope all with the same problem understand my explenation