Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
Creator
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:

Load * inline [

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].

Please help me as I was not able to do so.

1 Solution

Accepted Solutions
Master II
Master II

Is this what you are trying to achieve?

image.png

View solution in original post

3 Replies
Master II
Master II

Is this what you are trying to achieve?

image.png

View solution in original post

Creator
Creator

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

Happy to hear that.
If your Problem is solved please mark the answer as solution.

Have a nice Day

regards
Franky