topic Re: Common transformations in QlikView https://community.qlik.com/t5/QlikView/Common-transformations/m-p/1152570#M897459 <HTML><HEAD></HEAD><BODY><UL><LI>There is CrossTable load to load pivot table and Generic load to do the opposite of CrossTable.</LI><LI>You mentioned Peek, there is also Previous</LI><LI>Their is Hierarchy Load</LI><LI>You mentioned ApplyMap(), there is MapSubString()</LI></UL><P></P><P>I guess you can look on the help section to find many more functions like this:</P><P><A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/functions-in-scripts-chart-expressions.htm" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/functions-in-scripts-chart-expressions.htm">Functions in scripts and chart expressions ‒ QlikView</A></P></BODY></HTML> Wed, 27 Jul 2016 02:02:32 GMT sunny_talwar 2016-07-27T02:02:32Z Common transformations https://community.qlik.com/t5/QlikView/Common-transformations/m-p/1152569#M897458 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>What are the most common or generic transformations involved in most of projects in case of three layer architecture, below are some </P><P>examples I think, please add more</P><P></P><P>concatenate,interval match,applymap(),aggregation,join, keep,peek</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Common-transformations/m-p/1152569#M897458 2020-11-25T16:16:04Z Re: Common transformations https://community.qlik.com/t5/QlikView/Common-transformations/m-p/1152570#M897459 <HTML><HEAD></HEAD><BODY><UL><LI>There is CrossTable load to load pivot table and Generic load to do the opposite of CrossTable.</LI><LI>You mentioned Peek, there is also Previous</LI><LI>Their is Hierarchy Load</LI><LI>You mentioned ApplyMap(), there is MapSubString()</LI></UL><P></P><P>I guess you can look on the help section to find many more functions like this:</P><P><A href="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/functions-in-scripts-chart-expressions.htm" title="http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/functions-in-scripts-chart-expressions.htm">Functions in scripts and chart expressions ‒ QlikView</A></P></BODY></HTML> Wed, 27 Jul 2016 02:02:32 GMT https://community.qlik.com/t5/QlikView/Common-transformations/m-p/1152570#M897459 sunny_talwar 2016-07-27T02:02:32Z