topic c= a+b column total in pivot in QlikView

c= a+b column total in pivot

vikasmahajan — Tue, 23 Jun 2015 06:56:20 GMT

Find attached QVW and excel sheet have Group A,B, C ... like this columns now I want to display

C = A+B in total of pivot.

How to achieve the same

Vikas

Re: c= a+b column total in pivot

giakoum — Tue, 23 Jun 2015 06:58:56 GMT

column(1)+column(2)

Re: c= a+b column total in pivot

giakoum — Tue, 23 Jun 2015 07:00:00 GMT

or if you label the expressions, you can use the labels as well. See attached

Re: c= a+b column total in pivot

vikasmahajan — Tue, 23 Jun 2015 07:14:49 GMT

Dear Sir ,

Thanks reply Actually I want total in attached excel format please refer and give solution.

Vikas

Re: c= a+b column total in pivot

giakoum — Tue, 23 Jun 2015 07:23:23 GMT

I really don't see any difference between excel and QV. Could you please elaborate?

Re: c= a+b column total in pivot

vikasmahajan — Tue, 23 Jun 2015 07:46:56 GMT

I have different types of groups like A,B,C etc in pivot report now I want group total suppose c= a+b

please see image attached.

Vikas

Re: c= a+b column total in pivot

giakoum — Tue, 23 Jun 2015 08:01:25 GMT

to do that correctly you need to introduce a new dimension that will group A & B together.

See attached as example

Re: c= a+b column total in pivot

vikasmahajan — Tue, 23 Jun 2015 09:35:22 GMT

using new group and following expression solved my problem.

sum(if(wildmatch(Type,'Expense'),Amount * -1,Amount))

and if you don't want show Expense amount in negative then go to Number tab select Integer/Fixed to

and set below pattern

#,##0.00;#,##0.00;

Thanks

Vikas

Re: c= a+b column total in pivot

kavicsgym — Mon, 23 Nov 2015 14:19:24 GMT

Hi All,

Grouping seems ok in a simple example, but normally you have much more different blocks in a P&L where you have to sum up the Totals. Pls. see the modified xls from above, as an example, and the colored 'blocks'.

Then you may need 3-4 or more columns for grouping, and it will be very confusing in a Pivot chart.

So how to cope with that, or am I misunderstanding something? (I work on a PandL right now.... 🙂 )

Enikö