topic Re: Calculated dimension total in QlikView

Calculated dimension total

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have used calculated dimension but here i need to show total for this.

Calculated dimension: =aggr(sum({<Date={$(varMaxDate)}>} TOTAL_ORDERS_DAILY_NEW),Loc)

Table used : Pivot

Please find the below image.Here i need to show total of total orders.

Thanks..

Re: Calculated dimension total

Mon, 28 Nov 2016 08:43:21 GMT

Re: Calculated dimension total

MK_QSL — Mon, 28 Nov 2016 08:48:11 GMT

Use it as an expression rather than calculated dimension

SUM(aggr(sum({<Date={$(varMaxDate)}>} TOTAL_ORDERS_DAILY_NEW),Loc))

Re: Calculated dimension total

nareshthavidishetty — Mon, 28 Nov 2016 09:50:39 GMT

Hi,

Attached is the sample application in which i need total for the total orders column in the table.

Thanks..

Re: Calculated dimension total

nareshthavidishetty — Mon, 28 Nov 2016 11:13:54 GMT

Hi,

Please let me know if we can get this.

Thanks..

Re: Calculated dimension total

MK_QSL — Mon, 28 Nov 2016 11:17:16 GMT

Like this?

Re: Calculated dimension total

nareshthavidishetty — Mon, 28 Nov 2016 11:46:51 GMT

Hi Manish,

It's very smart.

But i need it to show in bottom of the report.

Thanks..

Re: Calculated dimension total

Anil_Babu_Samineni — Mon, 28 Nov 2016 12:13:37 GMT

Try to go Bottom and see whether values are there not not there? Would you confirm there. I got to see bottom with all values{I mean without any missing Total Values}

Would you check that?