topic Re: How would you create a variable such that it contained a list of dimensions? in QlikView

How would you create a variable such that it contained a list of dimensions?

Fri, 02 Jan 2015 15:50:23 GMT

Say I've got dimensions A,B,C instead of creating a 3 graphs for each dimension would it be possible to create a dimension/variable so that it would contain A,B,C and thus only having to create one graph?

Re: How would you create a variable such that it contained a list of dimensions?

jpenuliar — Fri, 02 Jan 2015 15:57:56 GMT

Do you mean a drill down or cyclic dimension for A,B, and C?

Re: How would you create a variable such that it contained a list of dimensions?

Fri, 02 Jan 2015 15:59:45 GMT

Drill down.

Re: How would you create a variable such that it contained a list of dimensions?

Fri, 02 Jan 2015 16:03:55 GMT

As Jonathan says, groups would work for you, have a look under document properties for the groups tabs and create a new cycle or drill down group for your 3 dimensions and then add this group to your chart.

hope that helps

Joe

Re: How would you create a variable such that it contained a list of dimensions?

engishfaque — Fri, 02 Jan 2015 16:04:38 GMT

Dear Haryharan,

Kindly use Drill-Down Group or Cyclic Group.

Here is the way,

Chart Property > Tab "Dimensions" > Button "Edit Group" > Button "New" > Select Radio Box "Drill-down group" or "Cyclic Group" > Assign Group Name > Add "Available Fields" > OK > OK > OK.

In final, add group name in your chart dimension.

Kind regards,

Ishfaque Ahmed

Re: How would you create a variable such that it contained a list of dimensions?

Anonymous — Fri, 02 Jan 2015 16:05:25 GMT

On your Chart Properties Dimensions tab :

Right click <Edit Groups>
Create a Group comprising your 3 dimensions
Add this Group you have just created as a dimension to the Chart.

Re: How would you create a variable such that it contained a list of dimensions?

jpenuliar — Fri, 02 Jan 2015 16:07:39 GMT

You can create a Drilldown or cyclic dimension group in qlikview.

You can try CTRL+Alt+D which ioens up Document Properties.

Click on Groups Tab and on Groups section you can Create New Group of Dimensions.

This Group you create can now be used as Dimension in your charts