topic Re: summary rows must display value other than expression total in QlikView

summary rows must display value other than expression total

Wed, 09 Mar 2016 12:36:41 GMT

I have 1 dimension say city. and one measure say weeklyavg of population in a pivot table.

when we go to presentation and clik on dimensions, partial sum option is available. it will display the summary of expressions. here I wanted another value to be displayed other than expression total.

Is there any way?

Re: summary rows must display value other than expression total

Kushal_Chawda — Wed, 09 Mar 2016 12:39:26 GMT

you use dimensionality() function.

if(dimensionality()=1, ExpressionTobe display , Actual Expression)

Re: summary rows must display value other than expression total

avinashelite — Wed, 09 Mar 2016 12:42:26 GMT

What is the additional value you need to display ??

can you explain with the example

Re: summary rows must display value other than expression total

Wed, 09 Mar 2016 12:50:17 GMT

u r close .

say suppose the display is as follows in pivot chart:

total 52

newyork 52

Atlanta 52

now, I wanted total to be displayed as 52.5(i.e 52.something)

actually the values are fixed to be displayed as numbers but I want the total to be displayed as decimals

Re: summary rows must display value other than expression total

Wed, 09 Mar 2016 12:50:25 GMT

u r close .

say suppose the display is as follows in pivot chart:

total 52

newyork 52

Atlanta 52

now, I wanted total to be displayed as 52.5(i.e 52.something)

actually the values are fixed to be displayed as numbers but I want the total to be displayed as decimals

Re: summary rows must display value other than expression total

avinashelite — Wed, 09 Mar 2016 12:58:16 GMT

try like this

if(dimensionality()=1, num(your_expression,'###0.0') , your_expression)

Re: summary rows must display value other than expression total

Kushal_Chawda — Wed, 09 Mar 2016 13:04:29 GMT

If(dimensionality() =1, round(sum(value),0.01),round(sum(value)))

If(dimensionality() =1, sum(value)&'something',sum(value))