Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Straight Table with user determined dimensions.

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

Accepted Solutions
vinay_bangari
Valued Contributor III

Re: Straight Table with user determined dimensions.

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

4 Replies

Re: Straight Table with user determined dimensions.

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
Honored Contributor III

Re: Straight Table with user determined dimensions.

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

Vikas

vinay_bangari
Valued Contributor III

Re: Straight Table with user determined dimensions.

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

MVP
MVP

Re: Straight Table with user determined dimensions.

Community Browser