Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Storing and Reusing QlikView Specific Expressions with QlikView Expressor

Employee
Employee

Storing and Reusing QlikView Specific Expressions with QlikView Expressor

Using QlikView Expressor (QVE) to manage and prepare data for QlikView is a great step towards adding data governance and data management to your QlikView deployment. Not only can you visualize where data originates and its final destination, but you can also create reusable parameterized business rules that can be shared across multiple applications.

By design QVE uses a Transform Operator to store Expression and Function rules to manipulate and/or add new data. When transforming data - a simple QVE expression is used. The result is a transformed or new data column(s) in the output of the final QlikView table model.

But what if you want to store and reuse an actual QlikView specific scripted expression and not just have the resulting column output? This would be an ideal method to reference a single version of that expression in a unified manner. In turn it could reduce maintenance significantly if changes are made since there is only one place to make modifications, QlikView Expressor. This approach would also increase productivity and data confidence as it creates a single common expression stored in a centralized reusable repository.

Sample is attached in this blog entry: http://community.qlikview.com/blogs/qlikviewdesignblog/2013/04/24/defining-qlikview-expressions-with...

Comments
Not applicable

Hi, Michael Tarallo

Where can I Download the QVE project and sample data pakage with this document?

Thank you.

Employee
Employee
Not applicable

Thank you. I am downlaoding now.

vadimtsushko
Contributor III

Hi, Michael

We are using rather like technique: storing expression, labels and comments outside QV application as described in InQlik Expression Editor in QlikView Deployment Framework environment

However in one respect our practice differ from your's:

When variables for labels and comments contain simple strings and do not require additional evaluation (almost allways in our case) we use lightweight formulas for chart label's expression

Taking example from your document:

Variable for label

Name: vMSR_SumOfSales_Label Value: 'Sum of sales'

Formula for chart expression label in your document: ='$(vMSR_SumOfSales_Label)'

Formula for chart expression label which we would use: =vMSR_SumOfSales_Label

Have you any reservations regarding `our` mode. Maybe it is worse performance-wise or have some other flaws?

Not applicable

I have a QVW with complex load scripts...

   if(GivewRel.GIFTAMTPLG = 0 and GivewRel.GIFTAMOUNT = 0,0,

      if((GivewRel.RELISA = 'self' and  GivewRel.RELWHOSE = 'self' and match(GivewRel.PTYPE,'g','p','e','c') and GivewRel.GIFTAMTPLG > 0) or

      (GivewRel.RELISA = 'don' and  GivewRel.RELWHOSE = 'givveh' and match(GivewRel.PTYPE,'g','p','e')and GivewRel.GIFTAMTPLG > 0), 1 ,

        if((GivewRel.RELISA = 'self' and  GivewRel.RELWHOSE = 'self' and match(GivewRel.PTYPE,'g','p','e','c') and GivewRel.GIFTAMOUNT > 0) or

      (GivewRel.RELISA = 'don' and  GivewRel.RELWHOSE = 'givveh' and match(GivewRel.PTYPE,'g','p','e')and GivewRel.GIFTAMOUNT > 0), 1,

        0))) as consec.DerivedQualifiedGiftPledgeCount         

 

AND

if(Previous(giftsXinY.CoreID) <> giftsXinY.CoreID, 1,rangesum(giftsXinY.ngifts,Peek(giftsXinY.GiftSum))) as giftsXinY.GiftSum

Can I use the technique you described to create these load scripts in Expressor?  If so, how?

Arjunarao
Honored Contributor II

Thanks for sharing.

Version history
Revision #:
1 of 1
Last update:
‎04-19-2013 02:56 PM
Updated by: