Easy in Qlik Script but hard in SQL

reanfadyl — Wed, 14 Jun 2017 21:50:49 GMT

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

Re: Easy in Qlik Script but hard in SQL

rwunderlich — Wed, 14 Jun 2017 22:58:28 GMT

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

topic Easy in Qlik Script but hard in SQL in QlikView

Easy in Qlik Script but hard in SQL

Re: Easy in Qlik Script but hard in SQL