topic Re: How to test the data after using cross table? in QlikView https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565451#M210980 <HTML><HEAD></HEAD><BODY><P>Guys any help on this?</P></BODY></HTML> Thu, 27 Mar 2014 07:33:27 GMT qlikviewforum 2014-03-27T07:33:27Z How to test the data after using cross table? https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565450#M210979 <HTML><HEAD></HEAD><BODY><P>Sorry for posting now qlikview question.</P><P></P><P>I have table which I have converted that to a cross table, something like below. So it will consider first 11 as attribute field name(out of 14 fields) and next 3 will be considered as field name.</P><P></P><P>Crosstable(Month,Sales,11)</P><P></P><P>My question is how can I test it out with production data which is not cross tabled to make sure the data is matching perfectly. For example I have created the QVD using the cross table by connecting to Production database and now I have test it out with the production QVD which is not cross tabled.</P><P></P><P>It would be great it someone suggest me on this though it is not related to qlikview.</P><P></P><P>Please help!</P></BODY></HTML> Thu, 27 Mar 2014 02:23:32 GMT https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565450#M210979 qlikviewforum 2014-03-27T02:23:32Z Re: How to test the data after using cross table? https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565451#M210980 <HTML><HEAD></HEAD><BODY><P>Guys any help on this?</P></BODY></HTML> Thu, 27 Mar 2014 07:33:27 GMT https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565451#M210980 qlikviewforum 2014-03-27T07:33:27Z Re: How to test the data after using cross table? https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565452#M210981 <HTML><HEAD></HEAD><BODY><P>You need to check with source file , If u r loading sales&nbsp; then sum (Sales) of source data should tally with loaded data in qvw from qvd.</P><P></P><P>Vikas</P></BODY></HTML> Thu, 27 Mar 2014 07:37:23 GMT https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565452#M210981 vikasmahajan 2014-03-27T07:37:23Z Re: How to test the data after using cross table? https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565453#M210982 <HTML><HEAD></HEAD><BODY><P>Can you please elaborate please?</P><P></P><P>I think we need to check the values before cross table has been and after cross table has been implemented. I little confused how to to do that.</P><P></P><P>Creating pivot table or something like that will it work out? Please suggest....</P></BODY></HTML> Thu, 27 Mar 2014 08:50:03 GMT https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565453#M210982 qlikviewforum 2014-03-27T08:50:03Z Re: How to test the data after using cross table? https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565454#M210983 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Compare your raw data with qlikview application. if it's correct then go for it.</P></BODY></HTML> Thu, 27 Mar 2014 08:55:28 GMT https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565454#M210983 2014-03-27T08:55:28Z Re: How to test the data after using cross table? https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565455#M210984 <HTML><HEAD></HEAD><BODY><P>Thank you</P><P></P><P>How to do that comparision? That is what my question is. Please advice!</P></BODY></HTML> Thu, 27 Mar 2014 08:57:08 GMT https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565455#M210984 qlikviewforum 2014-03-27T08:57:08Z Re: How to test the data after using cross table? https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565456#M210985 <HTML><HEAD></HEAD><BODY><P>hi,</P><P> Do some calculations in qlikview application and compare with raw data(manual calculation)</P><P> eg: sum(sale) in qlikview application</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; manually sum the sale in raw data and compare it..</P></BODY></HTML> Thu, 27 Mar 2014 09:11:56 GMT https://community.qlik.com/t5/QlikView/How-to-test-the-data-after-using-cross-table/m-p/565456#M210985 2014-03-27T09:11:56Z