topic Calculated Dimension in QlikView

Calculated Dimension

evansabres — Wed, 24 May 2017 15:42:16 GMT

I am looking to create a calculated dimension with multiple values of the same dimension.

The dimension is 'Opponent' and there are eight values. (Opponent A, Opponent B, Opponent C)

What is the syntax of the dimension?

Re: Calculated Dimension

micheledenardi — Wed, 24 May 2017 15:44:47 GMT

Try to use ValueList function:

Valuelist('Opponent A', 'Opponent B', 'Opponent C')

Re: Calculated Dimension

sunny_talwar — Wed, 24 May 2017 15:51:08 GMT

8 values? how are they getting into the three Opponents you mentioned (A, B, C)?

Re: Calculated Dimension

evansabres — Wed, 24 May 2017 15:55:02 GMT

That was an example, there are eight opponents

Re: Calculated Dimension

sunny_talwar — Wed, 24 May 2017 16:00:02 GMT

Why can't you use opponents as your dimension? Why do you need calculated dimension?

Re: Calculated Dimension

micheledenardi — Wed, 24 May 2017 16:03:10 GMT

In your chart use Valuelist('Opponent A', 'Opponent B', 'Opponent C') as a dimension and if() statement to specify the expressions for each dimension value

Re: Calculated Dimension

evansabres — Wed, 24 May 2017 16:03:33 GMT

There are values in there, which I do not want to have appear in the table.

Re: Calculated Dimension

sunny_talwar — Wed, 24 May 2017 16:06:18 GMT

Then you can use an if statement

If(Not Match(opponents, 'opponents9'), opponents)