QlikView blog round-up: If-statements, inline tables & EDX

By Barry Harmsen

DecisionsTime to dust off a posting category that hasn’t been getting as much love as it should have; the QlikView blog round-up. Today I have for you three blog posts that I read recently and found very interesting:


What a big “If” you have

In this post Chris Cammers describes a pretty cool and elegant method (reminiscent of decision tables) for dealing with big, nested if-statements. Chris’ method increases maintainability of your QlikView applications by ensuring that complicated logic can be modified with relatively little effort. Definitely something to have a look at. Click here for the full blog post.

Nifty trick for INLINE tables

As seen in a previous blog round-up, Bill Lay of The Qlik Board has a talent for discovering obscure menu options in QlikView. In this post, Bill describes a nifty trick that will save you time when creating INLINE tables based on an already existing field, for example to add an aggregation level. Click here for the full blog post.

EDX in QlikView

EDX allows you to trigger a QlikView Server task via an external event. As I’m currently working on a project that requires the use of EDX, I’ve been researching this subject quite a bit. One of the best articles that I came across is an introduction to EDX by Pablo Parnisari. In this introduction, Pablo describes what EDX is, how it is set up on the server-side and how you can trigger an EDX task using a macro in your QlikView application. In short, almost everything you want to know about EDX. The only thing that Pablo doesn’t explain is the meaning of the EDX acronym, if you know what it means please leave a comment 😉 Click here for the full blog post.

 

That’s it for my QlikView blog round-up. If you have some good articles or blog posts that you want to share, feel free to post them in the comments section.

About The Author

Barry Harmsen

Hi there, I'm Barry and I'm a Business Intelligence Consultant at Bitmetric and based in the Netherlands. Originally from a background of 'traditional' Data Warehousing, Business Intelligence and Performance Management, for the past 10 years I have been specializing in Qlik and a more user-centric form of BI. I have done numerous QlikView and Qlik Sense implementations in many different roles and industries. In 2012 I co-authored the book QlikView 11 for Developers. You can follow me on Twitter at @meneerharmsen.

4 Comments

  • 1
    October 18, 2011 - 15:40 | Permalink

    Thanks for the repost, I hope you all enjoy it!

    Chris

  • 2
    Jochem
    October 24, 2011 - 21:44 | Permalink

    EDX = Event Driven Execution ?

  • 4
    Jens Frederik
    October 27, 2011 - 11:23 | Permalink

    excellent post 🙂

  • Read previous post:
    Storing variables outside of QlikView

    Today I will show you how to store variables and their definitions in an external file... and why you would...

    Close