Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-07-14 07:19 AM

Double Excel-header

Hi,

I've got a problem with my data source (Excelsheet). I cannot manage the table format into a straight QV design.

I tried to take the Name of the "User" instead of the header into each data row, until the next User (same Excelsheet) follows. Here is an example of what it looks like:

screenshot.png

In QV table it should look like this:

User1     Start     End     Type...

User1     Start     End     Type..

User1     Start     End     Type...

User2     Start     Ende     Typ...

Has anybody an idea? Thanks a lot!

Ingo

700 Views
0 Likes
0 Replies