Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bhupaul87
New Contributor

How to write the Expression for Subtraction and multiplication?

Hi Community,

I am facing the same problem in my development, but i need to subtrct the two row from different columns in the same table.

Example:

Time 1 Time 2

3 2

6 3

Tatal 9 5 =4 (9-5)

Can you please suggest how can i write expression for 9-5= 4 and Multply 4 with some other number like 4*9=36.

Thanks

Bhupal

1 Solution

Accepted Solutions
Not applicable

Re: How to write the Expression for Subtraction and multiplication?

Hi Bhupal,

You can use total function i.e

Total(Sum(time1))- total(sum(time2)

and for the multiplication with other number

Total(Sum(time1))- total(sum(time2) * 4 (any number you wnat)

4 Replies
Not applicable

Re: How to write the Expression for Subtraction and multiplication?

Hi Bhupal,

You can use total function i.e

Total(Sum(time1))- total(sum(time2)

and for the multiplication with other number

Total(Sum(time1))- total(sum(time2) * 4 (any number you wnat)

anbu1984
Honored Contributor III

Re: How to write the Expression for Subtraction and multiplication?

MVP
MVP

Re: How to write the Expression for Subtraction and multiplication?

Rather:

=( sum(Time1) - sum(Time2) ) * 4

- Ralf

bhupaul87
New Contributor

Re: How to write the Expression for Subtraction and multiplication?

Hi All,

My problem is solved.

Thank You !

BR

Bhupal

Community Browser