Discussion board where members can get started with Qlik Sense.
I would like to get the latest recording from each group (myType is type column) from Apache hive table.
I use the following script at Qlik sense, but there is loading data error.
ROW_NUMBER() OVER (PARTITION BY myType ORDER BY myDate Desc) as LatestRow
Any suggestion is appreciated!
Go to Solution.
Finally we find the above script is right, while the problem comes from the Hive file.