topic basic data transformation in QlikView https://community.qlik.com/t5/QlikView/basic-data-transformation/m-p/302293#M1198616 <HTML><HEAD></HEAD><BODY><P>Hai Everyone,</P><P></P><P>I am new to QlikView and now i am reading the book Developer 1 of QlikView 10 version.</P><P>While i am preparing the book, i had a doubt in one page. And i will provide you line written in book, can anyone explain what to do and how to do.</P><P>//*****Lines in book*****</P><P>* Create a new chart object, and choose the pivot table chart type.</P><P>* Use CompanyName, ProductName and Month for the dimensions.</P><P>* The Expression should calculate the distinct number of product sold, and should be labeled[Toltal Products Sold]. Enable Show Partial Sums by CompanyName, and Month. This option can be found in the Presentation tab.</P><P>* Add a new expression for the number of Orders placed. Use the OrderIDCounter field for this calculation. Lable this expression[Number of Orders].</P><P>* Sort the CompanyName and ProductName dimensions by the same expression as [Number of Orders], in Descending order.</P><P>//***End of Lines*****</P><P></P><P>Thanks,</P><P>Venkat</P></BODY></HTML> Fri, 28 Jan 2011 06:54:43 GMT 2011-01-28T06:54:43Z basic data transformation https://community.qlik.com/t5/QlikView/basic-data-transformation/m-p/302293#M1198616 <HTML><HEAD></HEAD><BODY><P>Hai Everyone,</P><P></P><P>I am new to QlikView and now i am reading the book Developer 1 of QlikView 10 version.</P><P>While i am preparing the book, i had a doubt in one page. And i will provide you line written in book, can anyone explain what to do and how to do.</P><P>//*****Lines in book*****</P><P>* Create a new chart object, and choose the pivot table chart type.</P><P>* Use CompanyName, ProductName and Month for the dimensions.</P><P>* The Expression should calculate the distinct number of product sold, and should be labeled[Toltal Products Sold]. Enable Show Partial Sums by CompanyName, and Month. This option can be found in the Presentation tab.</P><P>* Add a new expression for the number of Orders placed. Use the OrderIDCounter field for this calculation. Lable this expression[Number of Orders].</P><P>* Sort the CompanyName and ProductName dimensions by the same expression as [Number of Orders], in Descending order.</P><P>//***End of Lines*****</P><P></P><P>Thanks,</P><P>Venkat</P></BODY></HTML> Fri, 28 Jan 2011 06:54:43 GMT https://community.qlik.com/t5/QlikView/basic-data-transformation/m-p/302293#M1198616 2011-01-28T06:54:43Z