Qlik Community

Qlik Education Documents

Documents related to Qlik Education.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.

Qlikview adhoc dimension analisys [My own example]

felipevianna
New Contributor

Qlikview adhoc dimension analisys [My own example]

Hi everybody,

I've been demanded recently customizable reports in Qlikview 11 and a way to accomplish this requirement was to let the users explore and design their own reports by adding or hiding columns and expressions.

I just wanted to share with everybody a simple example in which by loading inle sample dummy data we can create an small testing table and a chart which is using this Qlikview feature. Let's review it step by step :

1. Create an inline sample table with 3 or 4 dimensions and a couple of expressions:

2. Let's create now 2 data island in our model, those with contain all dimension names and expression names each data island.

3. Now we have all the data model built in our QVW. The idea here is to create a straight table containig the dimensions and expressions of the Data table and let the user select which ones will be displayed. Once we have the table created with our dimensions and our expressions we will need to put the following conditions:

Alt( WildMatch ( GetFieldSelections(%Dimensions,'|'), '*DIMENSION_NAME*' ), 0 )

Alt( WildMatch ( GetFieldSelections(%Dimensions,'|'), '*EXPRESSION_NAME*' ), 0 )

Then we can create 2 selectors, one for the dimensions and another one for the expressions using our data islands:

Now, whenever the user clicks on any checkbox the report will be constructed dinamically by using the conditional expressions which will search the dimension/expression name.

Comments
Not applicable

Hi Felipe,

When you create the table do you need to enter both of the expressions above? Can you post an example, I'm trying to replicate but having a little difficulty.

Thanks

0 Likes
cheburashka
Contributor III

Hello Felipe,

Ever thought of building an out of the box AdHoc analysis tool instead of listing the dimensions and measures? Maybe you'll like this solution.

,KR Koen

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2015-01-20 07:25 AM
Updated by: