topic Re: Can Qlikview generate a table based on users selecting fields and expressions from a drop down list in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

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

tresB — Mon, 16 Jan 2017 11:53:09 GMT

Check it here : Adhoc reporting in Qlikview

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

varshavig12 — Mon, 16 Jan 2017 11:54:50 GMT

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

Anonymous — Mon, 16 Jan 2017 15:24:43 GMT

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

Thanks

Greg

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

Anonymous — Mon, 16 Jan 2017 15:31:32 GMT

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

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

eespiritu — Mon, 16 Jan 2017 23:21:13 GMT

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.