Pivot table - do not show partial sums for expression

[#1]

Hi everyone,

In my pivot table, I have a partial sum defined on a dimension (with a count expresion). This shows a correct partial sum, this is fine and as expected.

But, just before the count expression, I have another expression using concat(). Is there a way to tell QV to show the value of concat in all cells but NOT in the partial sum row? Or is that an unavoidable consequence of using an expression?

Thanks in advance,

Jan

[tresesco · Accepted solution]

try using dimensionality() function.

http://community.qlik.com/message/322904#322904

[er_mohit]

Yeah for that you didn't enclose your expression in sum()

then your all data values comes except partial sum row like

simply write on  expression side here QuantifiableFieldname

hope it helps

[#4]

Thanks for your answer. However, I am sorry but I do not have a clue what you mean...

[#5]

I will have a look, thanks.

Update: Perfect, just what I needed! thanks again, have a nice weekend

[er_mohit]

if you write on expression tab  sum(fieldname)

then in partial sum shows the sub total

if you write Fieldname then it doesnot show the partial sum

hope it helps you

[#7]

All right, now I understeand what you mean, thank you.

Yeah, I did try that but my expression will not calculate as "calculated dimension", it only works as expression. But definately a helpful answer, thanks!