Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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