Set Analysis Wizard for QlikView

Do you normally succeed CREATING and DOCUMENTING a Set Analysis expression/formula like the following one in less than two minutes?


Sum({$<Year=,Month=,CustomerCountry=P({1<CategoryName={'Confections'}>}SupplierCountry),Customer=P({1<Year={$(=max(Year)-1)}>}Customer)>}Sales)

I do normally not! And even if I would, after two weeks I cannot remember why I have created this statement like this …

That’s why I have created the “Set Analysis Wizard for QlikView” ;-)

Introducing the Set Analysis Wizard for QlikView

So let’s directly jump to the result in the “Set Analysis Wizard for QlikView”:

If you open the above mentioned expression in the wizard, you’ll see the following:

And if you click on the tab “Generated Expression (+ Comments)” you’ll see the following:

You are welcome to add/change set modifiers at any time:

So what’s happening here?

By using the “Set Analysis Wizard for QlikView” you’ll now have a tool which

  • enables you creating Set Analysis Expressions in WYSIWIG mode (!!!)
  • Event the most complex Set Analysis Expressions will be documented automatically
  • optionally you can save the expression on the server and edit/change/enhance it at any time
  • furthermore you can share the created expression with others

Step by Step Instructions

Hopefully a step by step instruction is not necessary.
I have worked hard to create a self explanatory user interface (but if I did not succeed in your opinion, please do not hesitate to tell me!)

So just give it a try:

Open the Set Analysis Wizard for QlikView

Load the example mentioned at the beginning of this article



Examples

I have added some examples which can be directly opened in the wizard:

All examples can be opened directly in the wizard

Sharing your Set Analysis Expressions

Feel free to share your results.
Just click on “Save result for later usage and sharing” and two things will happen:

  1. The Set Analysis Expression will be saved on the server and you can come back later an re-edit it at any time.(The link for re-opening the Set Analysis Expression will be added to the comment of the expression automatically)
  2. Furthermore you can share your expression with colleagues, in discussion forums, and so on …
Enable "Save result for later usage or sharing" and "Share Expression"

Enable "Save result for later usage or sharing" and "Share Expression"

Roadmap

So far this is the first beta version.
I have not included QlikView 11 support (Alternate States) so far, but for sure, this is the next update you can expect …

Feedback, Improvements, etc.

Please give me feedback:

  • Do you like the Set Analysis Wizard?
  • What is missing?
  • Is it easy to use?
  • etc.
Bookmark and Share

and tagged , , , , , . Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

83 Comments

  1. Posted March 19, 2014 at 02:59 | Permalink

    Consider these latest numbers on areas when you want to buy a residence in L.A.
    Pipes, window frames, flooring, walls and gates, them all must be detailed
    appropriately.

    my weblog; Memphis Home Inspector

  2. Posted April 6, 2014 at 18:37 | Permalink

    Are probably you planning to move abroad that will
    hep study, work potebtially permanent basis? ‘State clearly in marketing why you
    really should try to fire the advisor.

    Here is my web site :: superlawyers

  3. Posted April 7, 2014 at 19:32 | Permalink

    A 24-hour valet service exists for Concoures B & C.
    You should expect to recoup the minimum expected start-up cost inside your
    first few games. That’s because land is becoming
    scarce and costs a fortune to buy.

    my web-site – Billy Lerner New York

  4. Posted April 7, 2014 at 20:08 | Permalink

    This form can bbe usxed even when there is no way new attorney.
    It’s not prudent to condemnation a lawyer.verbally.

    Here is my blog – criminal law

  5. Posted April 8, 2014 at 02:34 | Permalink

    ‘State clearly in website writing why you want to fire the lawyer.

    The lawyers will definitely be expert in handling such issues and absolutely have a good education of this trade.

    Also visit my weblog :: LinkedIn – http://www.linkedin.com/pub/dir/Rusty/Hensley,

  6. Posted April 13, 2014 at 04:39 | Permalink

    Some cello teachers want to train rapidly, while others
    would rather take their time and their particular rate.
    Look directly at the differednce between tight teacher and a negative teacher.
    Long-term goals should always be prioritized.

    My web blog http://leagle.com

Post a Comment

(required)
(required)

Your email is never published nor shared.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Subscribe without commenting