Latest Date

[EJSidloyi]

Good day

I have developed a model and I need to create 3 reports. I managed to create report 1. However the second and the third are giving me issues. 

Reports 2 - should be for the latest record for the selected L2Date for Pricedate1

I want to pick the latestd record

Reports 3 - should be for the latest record for the selected L2Date for Pricedate1 per scheme and L2Date(Summary

Sum({<L2Date ={"$(=Date(Pricedate,'YYYYMM'tput is per the attached filr))"}>} Unit cost)

The disired output is per the attachaed file.

Thanks Akha

[mato32188]

Hi EJ,

for report 3 try:

Dim - Scheme, L2Date

Measure - SUM({< [L2Date] = {"$(=aggr(max(L2Date),Scheme))"} >}[Unit Cost])

for report 2 try:

Dim - Scheme, Product, L2Date

Measure - SUM({< [L2Date] = {"$(=aggr(max(L2Date),Scheme, Product))"} >}[Unit Cost])

BR

m

[EJSidloyi]

Good day

Thank you, i tried but our results are still the same.In report 2, I still get all the other lines where as I expect to get the  records with maximum date and UniquePriceId(55).

The same for report 3 the summary figures are for the multiple lines not the maximum date though it shows one line per Scheme and L2Date.

In you formular you dont do anything about Pricedate1 which is the port important field.

Please help

E-J

Thank you

[mato32188]

Could you please share sample of your raw data? It would be better to look at the structure you load to Qlik and then find solution for you.

Thank you.

m