Discussion Board for collaboration related to QlikView App Development.
I have a table
DeviceID, EventDate, FirmwareVersion
This table gets refreshed regularly so a new event does not correspond to a new firmware. I want to have in a table DeviceIdD vs latest firmware version vs the date it detected the firmware.
In SQL I would do it like this
select e.DeviceID, e.FirmwareVersion, min(e.EventDate) DateFirmwareDetected
from Events e
select ev.DeviceID, ev.FirmwareVersion
from Events ev
select DeviceID, max(EventDate) EventDate
group by DeviceID
on ev.DeviceID = a.DeviceID and ev.EventDate = a.EventDate
on e.DeviceID = b.DeviceID and e.FirmwareVersion = b.FirmwareVersion
Can anybody help with putting this in Qlik?
Would you be able to share a sample of data and the output you expect to see from it?