Transformation steps in Qlikview (Excel File)

[Anonymous]

Hi All,

Could you please see the attached excel file and how can we transform the data for better understand..

In the excel spread sheet we have years like(2015,2016) below  the Quarter and Months ,this needs to be reflected in the dashboard as well.

Regards,

Devendar

[#2]

Hi Sunny,

Can I ask how you loaded the CrossTable? Did you change the field names in the excel table before loading it in and if so, why did you do that?

Thanks

[sunny_talwar]

I did not change anything in the sample data. Just did some manipulation in the script with the names that were picked by the script.