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
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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
‎2016-07-29 02:42 PM

Excel file format.

Hi I have attached an  excel file,In sheet 1 I have the original format and I want to convert that to the format as in sheet 2 in qlikview.

Can this be done ?

Thanks much.

Labels (1)
Labels
Sample file..xls
1,239 Views
0 Likes
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP
‎2016-07-29 03:29 PM

You can fix the data in the backend and see the way you want using a pivot table:

Capture.PNG

View solution in original post

Community_227228.qvw
1,138 Views
2 Replies
sunny_talwar
MVP
MVP
‎2016-07-29 03:29 PM

You can fix the data in the backend and see the way you want using a pivot table:

Capture.PNG

Community_227228.qvw
1,139 Views
vishsaggi
Champion III
Champion III
‎2016-07-29 03:31 PM

May be like this?

Capture.PNG

sample.qvw
1,138 Views
0 Likes