Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

Re: How to select dimensions

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

Re: How to select dimensions

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

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