topic Re: Row Total in a pivot in QlikView

Row Total in a pivot

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

I have a data set below in excel and i would like to get the Total based on the Payment Status displayed in Qlik View through a pivot.

Sales Number	Personnel	Sales Amt	Payment Status	Total
AAAAA	Ankle	75	Paid	75
BBBBB	Arm	50	Due	50
CCCCC	Hand	24	Paid	24
DDDDD	Fin	20	Paid	20
EEEEEE	Plank	30	Due	30
FFFFF	Hill	45	Due	45

I have attached the QlikView Output which I am unable to get the Total in a new column on its own on the extreme right. Is there anyway I am doing it wrong?

Re: Row Total in a pivot

prma7799 — Tue, 27 Jun 2017 09:47:47 GMT

You want like this???

Re: Row Total in a pivot

ahaahaaha — Tue, 27 Jun 2017 09:51:58 GMT

Hi,

May be as in attached file. You can use flag "Show partial sums"

Regards,

Andrey

Re: Row Total in a pivot

Tue, 27 Jun 2017 09:56:02 GMT

Check the attachment, if you are looking r something like this.

Re: Row Total in a pivot

Anonymous — Tue, 27 Jun 2017 10:42:38 GMT

Thanks,

I am unable to open forums qvw. Are you able to give a brief screen shot or the formula ?

Re: Row Total in a pivot

Anonymous — Tue, 27 Jun 2017 10:43:27 GMT

Thanks

I am unable to open qvw attachments in forums, are you able to provide the screen shot or formula?

Re: Row Total in a pivot

Anonymous — Tue, 27 Jun 2017 10:45:28 GMT

Thanks Andrey..

It worked..appreciate it