topic Pivot table - do not show partial sums for expression in QlikView

Pivot table - do not show partial sums for expression

Fri, 07 Jun 2013 13:03:56 GMT

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

Re: Pivot table - do not show partial sums for expression

tresB — Fri, 07 Jun 2013 13:13:21 GMT

try using dimensionality() function.

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

Re: Pivot table - do not show partial sums for expression

er_mohit — Fri, 07 Jun 2013 13:14:36 GMT

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

Re: Pivot table - do not show partial sums for expression

Fri, 07 Jun 2013 13:25:35 GMT

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

Re: Pivot table - do not show partial sums for expression

Fri, 07 Jun 2013 13:26:03 GMT

I will have a look, thanks.

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

Re: Pivot table - do not show partial sums for expression

er_mohit — Fri, 07 Jun 2013 13:31:24 GMT

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

Re: Pivot table - do not show partial sums for expression

Fri, 07 Jun 2013 13:42:27 GMT

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!