topic Re: Calculation in QlikView

Calculation

parvez933 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Calculation

Frank_Hartmann — Sat, 24 Nov 2018 10:22:07 GMT

Is this what you are trying to achieve?

Re: Calculation

parvez933 — Sat, 24 Nov 2018 10:40:44 GMT

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

Re: Calculation

Frank_Hartmann — Sat, 24 Nov 2018 10:42:21 GMT

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

Have a nice Day

regards
Franky