Solved: Excel file format. - Qlik Community

Report Inappropriate Content · ‎2016-07-29

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.

sunny_talwar · ‎2016-07-29

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

sunny_talwar · ‎2016-07-29

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

vishsaggi · ‎2016-07-29

May be like this?

Excel file format.