topic Re: Subtotal in pivot table in QlikView

Subtotal in pivot table

vijetas42 — Mon, 11 Jul 2016 13:44:26 GMT

Hi all,

I want to display only total values in pivot table wherever my are same for each row irrespective of column position.

Regards,

Vijeta

sunny_talwar — Mon, 11 Jul 2016 13:45:29 GMT

Not sure I am clear as to what you are looking for. Do you have a sample you can provide with the expected output?

vijetas42 — Tue, 12 Jul 2016 04:19:25 GMT

No Name Vendor Date value1 value2

1 n1 v1 28/09/2015 1243413 351355

2 n1 v1 28/09/2015 1243413 351355

total 1243413 351355

expected output,

No Name Vendor Date value1 value2

1 n1 v1 28/09/2015

2 n1 v1 28/09/2015

total 1243413 351355

karthikoffi27se — Tue, 12 Jul 2016 05:21:32 GMT

Hi Vijeta,

Can you use this function

=If(Count(Distinct Field1) = 1, Null(), Sum(Amount))

this should work.

Thanks

Karthik

sunny_talwar — Tue, 12 Jul 2016 09:51:42 GMT

May be use dimensionality() and/or SecondaryDimensionality() functions to populate only totals