topic Re: Working with complex excel in QlikView https://community.qlik.com/t5/QlikView/Working-with-complex-excel/m-p/695025#M1082267 <HTML><HEAD></HEAD><BODY><P>Budget and allocation is available for month, however actual and projection is available buyer wise and garment type wise , </P><P></P><P>i wanted to see what is the budget ,allocation ,actual and projection for a given month then at least ,&nbsp; i can identify the variance for the month</P></BODY></HTML> Wed, 02 Jul 2014 06:54:25 GMT 2014-07-02T06:54:25Z Working with complex excel https://community.qlik.com/t5/QlikView/Working-with-complex-excel/m-p/695023#M1082265 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Most of the analysis i do with the excel and its little bit difficult to standardise them to system readable format.</P><P>I would like to know how can i show the attached excel in qlikview. Could anyone help me on this</P><P></P><P>thank you</P></BODY></HTML> Wed, 02 Jul 2014 06:40:03 GMT https://community.qlik.com/t5/QlikView/Working-with-complex-excel/m-p/695023#M1082265 2014-07-02T06:40:03Z Re: Working with complex excel https://community.qlik.com/t5/QlikView/Working-with-complex-excel/m-p/695024#M1082266 <HTML><HEAD></HEAD><BODY><P>Crosstable will help you to some extend for data cleaning but in your case is really a complex one..</P></BODY></HTML> Wed, 02 Jul 2014 06:45:55 GMT https://community.qlik.com/t5/QlikView/Working-with-complex-excel/m-p/695024#M1082266 selvakumarsr 2014-07-02T06:45:55Z Re: Working with complex excel https://community.qlik.com/t5/QlikView/Working-with-complex-excel/m-p/695025#M1082267 <HTML><HEAD></HEAD><BODY><P>Budget and allocation is available for month, however actual and projection is available buyer wise and garment type wise , </P><P></P><P>i wanted to see what is the budget ,allocation ,actual and projection for a given month then at least ,&nbsp; i can identify the variance for the month</P></BODY></HTML> Wed, 02 Jul 2014 06:54:25 GMT https://community.qlik.com/t5/QlikView/Working-with-complex-excel/m-p/695025#M1082267 2014-07-02T06:54:25Z