Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
parvez933
New Contributor III

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
Frank_Hartmann
Honored Contributor II

Re: Calculation

Is this what you are trying to achieve?

image.png

3 Replies
Frank_Hartmann
Honored Contributor II

Re: Calculation

Is this what you are trying to achieve?

image.png

parvez933
New Contributor III

Re: Calculation

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

Re: Calculation

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

Have a nice Day

regards
Franky