topic Re: Straight Table with user determined dimensions. in Qlik Learning Discussions

Straight Table with user determined dimensions.

Mon, 19 Jan 2015 23:57:01 GMT

Take a Straight Table with user determined dimensions. On this sheet create a list box for users where they can select which dimensions they want to add to the chart. (Note: User should be able to add one or more than one dimensions to the chart). Dimensions: OrderID, EmployeeID, Empy_Name, Office, ProductID, ProductName, SupplierID, Year, Month, Day, CustomerID, CompanyName etc.

Re: Straight Table with user determined dimensions.

marcus_sommer — Tue, 20 Jan 2015 11:21:30 GMT

You could use conditions on dimensions and expressions to create such a chart. Have a look on the demo-app "What's new ..." in your install-folder or here: http://us-b.demo.qlik.com/detail.aspx?appName=Whats%20New%20in%20QlikView11.qvw

- Marcus

Re: Straight Table with user determined dimensions.

vikasmahajan — Tue, 20 Jan 2015 11:23:30 GMT

You can use ad-hoc reporting option user will select dimension and report will be generated.

Vikas

Re: Straight Table with user determined dimensions.

Anonymous — Tue, 20 Jan 2015 14:52:15 GMT

first define a inline table:

Dimensions:

LOAD * INLINE [

ID, feildname

1, OrderId

2, EmployeeID

3, Employee_Name

....

];

Note the field names should be same as your dimension names. add a dimension in your chart and edit the dimension and write below script then it will work automatically. add this subfield function for all the dimensions you would like to add.

=$(=subfield(GetFieldSelections(feildname,',',1))

Re: Straight Table with user determined dimensions.

maxgro — Tue, 20 Jan 2015 18:21:00 GMT

there are a lot of resources in the community about ad hoc reporting

I like these

Customizable Straight Table

Dynamic Tables - An alternative approach to CONCAT using BIT operators

Dynamic Tables and Graphs

QlikView How To (or Tips & Tricks) Application