A Better Ad Hoc Listing

    The attached application shows you how to create a data-driven Ad-Hoc listing just using variables.  Using a data-driven approach you can also "copy" dimensions and expressions to an Ad-Hoc listing so the user can add additional columns.

     

    An Ad-Hoc listing is a table where the user can choose what dimensions and expressions from the data model are displayed.

    This is a very powerful means of examining the data.

     

    Customarily in QlikView this has been done by creating a straight or pivot table and adding all possible expressions and dimensions.

    Conditional expressions are added to each dimension and expression so that when the user selects a dimension or expression name from a list box, the associated columns are made visible in the table. This approach has a big drawback: the columns pop up wherever they were defined, not in the order selected.  Needless to say this looks very unprofessional.  The user shouldn't have to move columns around to fix their listing which was correct when they entered it.

     

    It would be great if an Ad-Hoc listing could be created which preserves the order of selections.  To make this data-driven would be an additional plus.  This could be done with macros, dynamically creating a table using the API.  But macros have a number of drawbacks and essentially Qlik's position is that they should not be used.

     

    The attached application shows you how to create a data-driven Ad-Hoc listing just using variables without any macros.

    This approach preserves the order dimensions and expressions appear for a more polished listing.

    The user can create an Ad-Hoc listing and then save the listing in a bookmark for later use.

    In addition, you can attach icons to every graph and table in your application which will allow the user to apparently "copy" the dimensions and expressions used into an Ad-Hoc listing for detailed analysis.

     

    I'll just provide a cookbook approach to just getting an Ad-Hoc listing working without going into how it's done.

    If there's any interest I'll provide some explanation of how it works.

     

    Download the sample application and associated spreadsheet and place them together in the same folder

    Explore the application to see how the Ad-Hoc listing works and how a chart can "copy" dimensions and expressions to the listing

    To create an Ad-Hoc listing for your own application, see the recipes in the attached document.