topic Re: Subtotaling Customization in QlikView

Subtotaling Customization

Anonymous — Tue, 14 Apr 2015 10:04:06 GMT

Hello!

I have this table that make the different behind the two expressions 2012 and 2013,

lost in 2013 : if((Column(1)-Column(2))=-1,'0',(Column(1)-Column(2)))

But the total's label is wrong, becouse it doesn't read the "IF condition" (Column(1)-Column(2))=-1,'0).

How can I Customization it?

Cliente	2012	2013	Lost in 2013
Total	160	174	-14
A&D SRL	0	1	0
ACCENTURE OUTSOURCING SRL	1	0	1
ACCENTURE S.p.A.	1	1	0
ACOMON S.R.L.	1	1	0
ACTIV8 CONSULTING SRL	0	1	0
ADDRESS SOFTWARE SRL	1	0	1
ALLIANZ S.p.A.	1	1	0

Re: Subtotaling Customization

marcus_sommer — Tue, 14 Apr 2015 13:52:59 GMT

You need to make it more clear what is wrong and what will be the expected result. I assume you will need a different expression for total and/or and an aggr, maybe in this way:

if(dimensionality() > 0, YourExpression,

sum(aggr(Expression2012, Cliente)) - sum(aggr(Expression2013, Cliente)))

- Marcus

Re: Subtotaling Customization

Anonymous — Thu, 16 Apr 2015 12:20:21 GMT

Peferct!

Thank you very much!!