topic Re: Pivot table totals in QlikView

Pivot table totals

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

hi all,

i want pivot table total for all measures except a measure which has text in it. below column is present in my table and i dont want any total for this measure.

Re: Pivot table totals

dapostolopoylos — Fri, 08 Mar 2019 12:56:55 GMT

Why don't you move this column to the dimension part of your chart?
It is not a measure, why bother find ways to supress totals for this column?

Re: Pivot table totals

sunny_talwar — Fri, 08 Mar 2019 12:08:26 GMT

May be do this

If(Dimensionality() = 0, Null(), <YourExpression>)

Re: Pivot table totals

fallenangel6 — Fri, 22 Mar 2019 12:10:22 GMT

this is displayed using the difference of two measures ie sum(grn qty)-sum(po qty).

Re: Pivot table totals

fallenangel6 — Fri, 22 Mar 2019 12:13:07 GMT

it doesnt work. this is my expression.

If(Sum(INVOICE_QUANTITY)=0,'No Invoice',
If(Sum(INVOICE_QUANTITY)<Sum(GRN_QUANTITY),'Partial Invoice',
If(Sum(INVOICE_QUANTITY)=Sum(GRN_QUANTITY),'Full Invoice',
If(Sum(INVOICE_QUANTITY)>Sum(GRN_QUANTITY),'Higher Invoice'))))