Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

subtraction of 2 records

Hi

I need to substract two values of 'Volume' within the following table depending on 'Date' but have no clue how to do that

The logic should be: 'Volume' of maxString(Date,1) - 'Volume' of maxSting(Date,2) [here 20'000-10'000]

Date Volume
30.06.2009 5'000
01.07.2009 10'000
03.07.2009 20'000

Has anybody an idea how to do that?

Many Thanks!!

1 Solution

Accepted Solutions
Not applicable

subtraction of 2 records

Hi,

see the attached example (Quantity - Above(Quantity))!

Good luck!

Rainer

View solution in original post

1 Reply
Not applicable

subtraction of 2 records

Hi,

see the attached example (Quantity - Above(Quantity))!

Good luck!

Rainer

View solution in original post