Set Analysis Wizard for QlikView

By Stefan Walther Comments closed
This entry was posted in Creating Applications, QlikView-Online-Tools

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.

Possibly related posts:

  1. Set Analysis Wizard as a Document Extension?
    It is really amazing: Since I have published the Set Analysis Wizard some months ago this is by far the most requested resource on my blog: About 300 unique QlikView developers / day are using...
  2. QlikTip #24: Using line-styles in Line-Charts to differentiate between actual and planning figures
    Some months ago I was asked how one could change the line style within a “Line Chart” for distinguishing between actual and planning figures. The desired result: How can we manage that in QlikView? First...
  3. QlikTip #28: Configuring “Associative Search” in QlikView 10
    In QlikTip#26 I announced to write some details on how to configure “Associative Search” in QlikView 10. First of all I’d like to bring the following article on “Associative Search” to your attention which has...
Bookmark and Share
Published: December 3, 2011
and tagged , , , , , . Bookmark the permalink. Both comments and trackbacks are currently closed.

86 Comments

  1. QlikQuickView
    Posted May 6, 2014 at 15:32 | Permalink

    Thanks a lot for your valuable articles!

    I would like to know whether you do or intent to share the source code for this application ?

    Thanks in advance,
    Best Regards,
    vand

  2. QlikQuickView
    Posted May 6, 2014 at 15:32 | Permalink

    Thanks a lot for your valuable articles!

    Iwould like to know whether you do or intent to share the source code for this application ?

    Thanks in advance,
    Best Regards,
    vand

  3. QlikQuickView
    Posted May 6, 2014 at 19:45 | Permalink

    Is it possible to query your Generator from JavaScript application ? How could I learn more about how to proceed ?

    Thanks again for sharing this tool!!

    Regards.

  4. QlikGenerator
    Posted May 20, 2014 at 09:20 | Permalink

    Good Morning,
    I would like to know whether you already plan to have this tool in QLikView product?What would be the timeline?
    Best Regards

    • Stefan Walther
      Posted May 24, 2014 at 22:08 | Permalink

      The Set Analysis Wizard is a private project (as everything on this page), therefore there are no plans to integrate it into the product!

      Regards
      Stefan

  5. Klaus Schmid
    Posted May 29, 2014 at 14:17 | Permalink

    Great tool, thanks for sharing!
    As a beginner in Qlikview, it helps a lot!

  6. compro oro
    Posted June 16, 2014 at 09:33 | Permalink

    Useful info. Lucky me I discovered your site unintentionally, and I am shocked why this coincidence didn’t happened in advance!
    I bookmarked it.

  7. Anonymous
    Posted June 20, 2014 at 22:00 | Permalink

    Appreciating the time and energy you put into your website and in depth information you present.
    It’s good to come across a blog every once in a while that isn’t the
    same unwanted rehashed information. Wonderful read! I’ve saved your site and I’m including
    your RSS feeds to my Google account.

  8. p78431
    Posted July 3, 2014 at 16:04 | Permalink

    Um diese Sicherheit und unseren Kundenservice zu gewährleisten, haben wir für Veranstaltungen wie z.B.
    Popcorn in Tüten – ein erfolgreiches Ges Die Firma G-Corn beschäftigt
    sich seit geraumer Zeit mit dem Verkauf von Popcornspezialitä.
    Aachen Aichach Alsdorf Arnsberg Bad Hersfeld Bad Kreuznach Baden-Baden Bayreuth Bergisch Gladbach Bruchsal Dettelbach Dormagen Dresden Eisenach
    Elmshorn Erding Eschwege Euskirchen Frankfurt Freyung Friedrichshafen Goslar Gotha Hamm Kassel Königsbrunn Kulmbach Leipzig
    Leverkusen Limburg Lippstadt Lörrach Mannheim Marburg Meitingen Memmingen Münster Naumburg Neckarsulm Neu-Ulm Neufahrn Neumünster Nürnberg Olpe Paderborn Passau
    Penzing Pforzheim Reutlingen Rudolstadt Saalfeld Selb Siegburg Singen Suhl Troisdorf Ulm Vilsbiburg Warburg Wiesbaden Bitte wählen Sie Ihre Stadt Aachen Aichach Alsdorf
    Arnsberg Bad Hersfeld Bad Kreuznach Baden-Baden Bayreuth Bergisch Gladbach Berlin Bruchsal Dettelbach
    Dormagen Dresden Eisenach Elmshorn Erding Eschwege Euskirchen Falkensee Frankfurt Freyung
    Friedrichshafen Goslar Gotha Hamm Kassel Königsbrunn Kulmbach Leipzig Leverkusen Limburg Lippstadt Lörrach Mannheim
    Marburg Meitingen Memmingen Münster Naumburg Neckarsulm Neu-Ulm Neufahrn Neumünster Nürnberg Olpe Paderborn Passau Penzing Pforzheim Reutlingen Rudolstadt Saalfeld Selb Siegburg Singen Suhl Troisdorf Ulm Vilsbiburg Warburg Wiesbaden.