Pivot Table - Calculated Dimensions

[Anonymous]

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

[YoussefBelloum]

Hi,

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

read this:

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

[Anonymous]

Hi youssefbelloum,

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

[YoussefBelloum]

did you read carefully the help ?

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

[agigliotti · Accepted solution]

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.