# New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a \$200 Amazon Gift Card! Watch Video
cancel
Showing results for
Did you mean:
Creator

## Calculation

Hi Everyone,

I got a scenario where, I was supposed to calculate the date type from the date where it needs to be added.

Ex:

Item,  DOP,  Day,  DOE

Milk1, 01/01/2018, 10

Milk2, 02/01/2018, 2

Milk3, 03/01/2018, 5

Milk4, 04/01/2018, 1

Milk5, 05/01/2018, 1

Milk6, 06/01/2018, 3

];

DOP: Date of Purchase, Days: Number of days the product will stay fresh/no of days to expire, DOE: Date of Expiry

Question:

I was supposed to use a straight table to display Item as dimension and DOE [by adding DOP + days]. Once I get the DOE, I have to sort the data according to DOE [The 1st product in the list is which to be expired first].

1 Solution

Accepted Solutions
Master II

Is this what you are trying to achieve?

3 Replies
Master II

Is this what you are trying to achieve?

Creator
Hey Hi Frank!
Thank you for your response. This is the output I was expecting. It is working!
Master II
Happy to hear that.