Can Qlikview generate a table based on users selecting fields and expressions from a drop down list

[Anonymous]

I would like users to be able to create their own tables/charts in Qlikview based on them selecting fields for rows, columns and expressions in the table from drop-down lists.  Is there an easy way to do this?

Thanks

Greg

[tresesco]

Check it here : Adhoc reporting in Qlikview

[Anonymous]

..and is it possible to show the dimensions and metrics as a drop-down list rather than a list box/check box?

Thanks

Greg

[Anonymous]

I think you could do it with a multibox as dropdowns.

[eespiritu · Accepted solution]

Hi Greg, yes is possible.

The way that you can use is create the full table with all dimensions and all expressions.

You need create 2 different island tables in your data model, one for dimensions and other for expressions (you need specify each dimension/expression name):

Dimensions:

LOAD * INLINE [

    dimensions

    Dimension 1

  Dimension 2

];

Expressions:

LOAD * INLINE [

    expressions

    Expression 1

  Expression 2

];

Now that you have these 2 different tables, you can create the filters for dimensions and expressions. Use a list box, in Presentation tab select 'Windows Checkboxes' as Selection Style Override. You can name these new filters as 'Pick Dimensions' and 'Pick Expressions'.

Once that you have the table with all dimensions and expressions, go to Dimensions tab in the table properties, and check the 'Enable Conditional' checkbox, use this code to validate when it will be shown:

=SubStringCount(Concat(dimensions, '|'), 'Dimension 1')

Apply the same code in the Conditional box for each expression. Remember to change the field/value in each dimension/expression.

The result is a dynamic table that you already created with all dimensions and expressions but the users can select only the dimensions and expressions that they need.

Let me know if this is what you was looking for.

Regards,

Enrique.