Qlik Community

Qlik Sense Cloud Discussions

Not applicable

Add a calculated row to a table

Hello,

Let' say I have a pivotal table as follows in Qlik Cloud:

Product\Day01020304
12622
23932
34035
45114
Calculated Row168288117143

Where the fomula is the sum of each day * sum of the product during all the days, for the product 1 it would be = (2+3+4+5)*(2+6+2+2+0) = 168.

I have been looking around with no results, is such a thing even possibe?

Thanks.

3 Replies
vinieme12
Esteemed Contributor II

Re: Add a calculated row to a table

The TOTAL keyword will solve your problem

Read below post

When should the Aggr() function NOT be used?

It's basically  =  Sum( TOTAL <Day>  Expression) * SUM(TOTAL <Product>  Expression)

Not applicable

Re: Add a calculated row to a table

Dear Vineeth thanks for your answer.

The problem I'm struggling with is adding the row in the design. Once I have the formular, how can I add a static row in the Pivotal Table where the value shown per day(Columns) is the one defined by the formula you've given me?

Thanks you

vinieme12
Esteemed Contributor II

Re: Add a calculated row to a table