Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fgillen1
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'

qlik.JPG

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

Any ideas?

Finbar

1 Solution

Accepted Solutions
agigliotti
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
YoussefBelloum
Esteemed Contributor

Re: Pivot Table - Calculated Dimensions

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...

fgillen1
New Contributor III

Re: Pivot Table - Calculated Dimensions

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
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 ?

agigliotti
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.