Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to select dimensions

I have created a table where it contains three subjects English, Maths and Science now i need to separate each subject into single single table . can anyone help me how to select the dimensions

below i have attached details of the table and the dimension which is already selected

2 Replies
swuehl
MVP
MVP

If you are using e.g. a bar chart, there is the trellis option on dimension tab to create multiple graphs per dimension value. This option is not available for table charts.

In general, you can create multiple chart objects and limit the dimension value to a specific one either by using a calculated dimension or set analysis in all your expressions:

1) Calculated dimension in dimension tab instead of the field dimension

=If(Subject = 'English', Subject)

[and suppress when value is NULL on dimension tab]

or

2) Set Analysis

Something like

=Avg( {<Subject = {'English'}>} Score)

in all your aggregation functions.

Hope this helps,

Stefan

jlongoria
Creator
Creator

The link below has very good information about calculated dimensions in general.

https://community.qlik.com/blogs/qlikviewdesignblog/2014/04/08/calculated-dimensions