Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

How to Make Total as Zero

Hi All,

We are building the Trail Balance Report in straight table and we have to make the sum of straight table Expression value to Zero by adding the appropriate amount dynamically at the end.

Here is the scenario with example:

Let us say, in the below table total is 640 but we have to show the total as zero.

Dimension

Expression

A

100

B

200

C

220

D

120

Total:

640

So, the requirement is we will be given a constant value for a dimension (Let us say it is E here) and whenever the total is not zero in the table we have to add the appropriate value dynamically against the dimension (Value: E) to make it zero. Below is the desired output:

Dimension

Expression

A

100

B

200

C

220

D

120

E

-640

Total:

0

In the above table we have to add -640 to make it zero. How to achieve this in Qlikview Straight Table? Any help is appreciated!!! Please help it is urgent.

Regards,

Deepak

3 Replies
Partner
Partner

Re: How to Make Total as Zero

Try with

=if(Dimension='E',Sum(TOTAL Expression)*-1,Sum(Expression))

and set the total mode of the expression to Sum of rows

Frank_Hartmann
Honored Contributor II

Re: How to Make Total as Zero

have a look at the attached sample.

hope this helps

enriquem
Contributor

Re: How to Make Total as Zero

Hi,

Why you don't try to use variables??

You can use a variable like:

SET totalValue = ''-' & =Sum(Expression)';

Hope this help.

Kind Regards,
Enrique Mora.