Storing Expressions Into a Data Island

Recently I talked about where to store variables once you’re ready to move your dashboard from development to live. Storing QlikView expressions into a data island will help ensure your dashboard remains accurate and will reduced development time further down the line by making changes a one step process.

This video covers storing expressions into a data island. A future shows how we can use this data island to create charts that a user can choose their own dimensions and expressions

Note: I’ve recorded the videos in highest resolution possible. So please view them in 1080 or 720P (HD) for best quality. Cheers!

https://www.youtube.com/watch?v=KTLXPx2f9wk

 

6 responses to “Storing Expressions Into a Data Island

  1. Pingback: Where to store your expressions in QlikView? | qlikcentral·

  2. Richard,
    how about this?:
    Using the User Defined Function as Rob Wunderlich described on his blog to avoid the multiple programming of the only syntax?
    I tested with a variable like this:
    UDF = $(=only({1}Expression))
    and then in in charts: $(UDF(sumValue)) and $(UDF(sumValue))/$(UDF(sumQuantity)) and $(UDF(Percentage))etc.

    Like

  3. Pingback: User Controlled Charts in QlikView | qlikcentral·

  4. Pingback: Automatically Create Point in Time Expressions | qlikcentral·

  5. Very cool Richard. I followed this advice in a recent project with a bunch of engineering formulas – adjusting the formulas afterwards was a breeze. Thanks for another great tip.
    I also used Michiel’s advice and created a UDF function – worked nicely.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s