Straight Table with user determined dimensions.

[#1]

1. 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.

[marcus_sommer]

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

[vikasmahajan]

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

Vikas

[Anonymous · Accepted solution]

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))

[maxgro]

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