topic Re: How to select dimensions in QlikView

How to select dimensions

Mon, 04 Apr 2016 05:51:26 GMT

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

Re: How to select dimensions

swuehl — Mon, 04 Apr 2016 09:38:30 GMT

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]

2) Set Analysis

Something like

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

in all your aggregation functions.

Hope this helps,

Stefan

Re: How to select dimensions

jlongoria — Mon, 04 Apr 2016 14:14:55 GMT

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

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