Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

How to compute Stock amount pick the latest date Stock Amount ?

Hi All

My raw data at Table 1 .

SOURCE GL_CODE_ GL_DESC_ Amount date
-
PM..... 2001010..... STOCK..... 18.00 ....21/09/2019
PM..... 2001010..... STOCK..... 14.00 ....21/10/2019
PM..... 2001010..... STOCK..... 19.00 ....21/11/2019
PM..... 2001010..... STOCK..... 22.00 ....21/12/2019
PM..... 2001010..... STOCK..... 14.00.... 21/01/2020
PM..... 2001010..... STOCK..... 12.00.... 21/02/2020
PM..... 2001010..... STOCK..... 9.00 .....21/03/2020
PM..... 2001010..... STOCK..... 6.00..... 21/04/2020

The latest data (on 21/4/20) Amount = 6

I need to make my Table (A) display 6.

Hope some one can advise me.

Paul

2 Solutions

Accepted Solutions
Highlighted
Master II
Master II

Re: How to compute Stock amount pick the latest date Stock Amount ?

Highlighted
Master II
Master II

Re: How to compute Stock amount pick the latest date Stock Amount ?

i would flag the max date per year in script and then using this information to find the values

View solution in original post

3 Replies
Highlighted
Master II
Master II

Re: How to compute Stock amount pick the latest date Stock Amount ?

Highlighted
Master
Master

Re: How to compute Stock amount pick the latest date Stock Amount ?

Hi Sir

Thank you very much , it work fine now.
In case I need to change SET analysis . So that I can compare the stock amount compare to one year ago the stock amount it is up or down. May I know how to do it ?

Paul
Highlighted
Master II
Master II

Re: How to compute Stock amount pick the latest date Stock Amount ?

i would flag the max date per year in script and then using this information to find the values

View solution in original post