Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
Not applicable

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.

1 Solution

Accepted Solutions

Re: Excel file format.

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

2 Replies

Re: Excel file format.

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

vishsaggi
Esteemed Contributor III

Re: Excel file format.

May be like this?

Capture.PNG