# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Contributor II

## Straight Table Calculation for the Previous Date Formula

Hi friends!

Help to write the formula that calculates values for the previous period inside current period in chart.

Like on screenshot below:

Trying to calculate measure "VALUE PREV DATE"

Sum(Aggr(sum({<Date={"\$(=If(Dimensionality()=0,
Date),-1))),
Date),-1)))))"}>}  [VALUE]),TB))

Doesnt works, because showing single value

11 Replies
MVP

## Re: Straight Table Calculation for the Previous Date Formula

What output you are looking for?

Contributor II

## Re: Straight Table Calculation for the Previous Date Formula

Like that:

 TB DATE VALUE PREV DATE VALUE PREV DATE 1 01.01.2017 100 2 02.01.2017 200 01.01.2017 100 3 03.01.2017 300 02.01.2017 4 04.01.2017 400 03.01.2017 5 05.01.2017 500 04.01.2017
MVP

## Re: Straight Table Calculation for the Previous Date Formula

Only 100?

No value for other columns?

Contributor II

No It's not

MVP

## Re: Straight Table Calculation for the Previous Date Formula

I mean you want 100 for last column and 2nd Row only...
what about 3rd row, 4th row etc?

No value?

What is the logic behind the 100?

Contributor II

## Re: Straight Table Calculation for the Previous Date Formula

My falt. I need to get table like this:

 TB DATE VALUE PREV DATE VALUE PREV DATE 1 01.01.2017 100 02.01.2017 200 2 02.01.2017 200 03.01.2017 300 3 03.01.2017 300 04.01.2017 400 4 04.01.2017 400 05.01.2017 500 5 05.01.2017 500
Contributor II

Any ideas ?

MVP

## Re: Straight Table Calculation for the Previous Date Formula

Is this Previous Date or Next Date?

Your Date Format is DD.MM.YYYY or MM.DD.YYYY?

Contributor II