If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I need to display the latest record only of specific SN based on date and time from transformed QVD. Table should return one row per SN.
You can calculate the max datetime and then group by it with all the fields in the script.
you could try with
FirstValue(PI_Machine) as PI_Machine,FirstValue(PI_Result) as PI_Result,FirstValue(PI_Date) as PI_Date,FirstValue(PI_time) as PI_timeFrom Raw_QVD (qvd)Group BySNorder byPI_Date desc,PI_time desc;
I encountered error on Order by. See below link.
sorry I forgot an important detail:
you could use order by only if you had loaded the table before.
So, you could load it and than, use the same script using resident
I'm loading my script using raw qvd file only not from database.