Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
The link below has very good information about calculated dimensions in general.
https://community.qlik.com/blogs/qlikviewdesignblog/2014/04/08/calculated-dimensions