# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## Pivot Table - Calculated Dimensions

Hi,

I have simple pivot table where I am getting the sum of population of areas within the different catchments below.

However I want to create new calculated dimensions within the pivot table like;

'< 15k' + '15k-30k'

and '< 15k' + '15k-30k' + '30k-50k'

and '< 15k' + '15k-30k' + '30k-50k' + '50k-100k'

I thought using the match function would allow me to do this but it doesn't work.

Any ideas?

Finbar

Tags (3)
1 Solution

Accepted Solutions
Honored Contributor II

## Re: Pivot Table - Calculated Dimensions

in your expression you should use something as below:

=if( ValueList('< 15k','15k-30k') = '< 15k', your_expression_1,

if( ValueList('< 15k','15k-30k') = '15k-30k', your_expression_2 ) )

hope this helps.

4 Replies
Esteemed Contributor

## Re: Pivot Table - Calculated Dimensions

Hi,

you should be able to solve this using ValueList() function

https://help.qlik.com/en-US/sense/September2017/Subsystems/Hub/Content/ChartFunctions/SyntheticDimen...

New Contributor III

## Re: Pivot Table - Calculated Dimensions

I am using it like this but it doesn't recognize it. Should I be referencing the filed name somewhere too?

=ValueList('< 15k','15k-30k')

Regards

Finbar

Esteemed Contributor

## Re: Pivot Table - Calculated Dimensions

did you read carefully the help ?

did you use it in the dimension expression AND the measure expression ?

Honored Contributor II

## Re: Pivot Table - Calculated Dimensions

in your expression you should use something as below:

=if( ValueList('< 15k','15k-30k') = '< 15k', your_expression_1,

if( ValueList('< 15k','15k-30k') = '15k-30k', your_expression_2 ) )

hope this helps.