Easy in Qlik Script but hard in SQL

[reanfadyl]

Hi All,

I have read that there are things that are easy to do in Qlik Script but hard to do in SQL (ETL: Qlik Scripting vs Sql query | Qlik Community).  Does anyone have good examples of this? 

I have been working with Qlik for a while, but have less experience with SQL and am curious as to how they compare.

Best regards

Rean

[rwunderlich]

Qlik Script has a number of features designed to server the specialized requirements of Qlik Transformation and Dimensional Modeling. A few things that come to mind that are easy in Qlik but harder in SQL:

1. MAPPING.  Whether data mapping or "RENAME FIELDS USING mapname" the Qlik solution is simple and elegant.

2. IntervalMatch.

3. Qlik Script provides more Datetime functions than a typical SQL implementation. For example, "InYearToDate()".

-Rob

http://masterssummit.com

http://qlikviewcookbook.com