Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for
Did you mean:
Creator 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

What output you are looking for?

Creator II
Author

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

Only 100?

No value for other columns?

Creator II
Author

No It's not

MVP

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?

Creator II
Author

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
Creator II
Author

Any ideas ?

MVP

Is this Previous Date or Next Date?

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

Creator II
Author

Previous Date like Date(MonthEnd(AddMonths(max(Date),-1)))).

Date format DD.MM.YYYY

Community Browser