topic Qlikview script equivalent of SQL code in QlikView

Qlikview script equivalent of SQL code

Thu, 10 Mar 2011 00:55:04 GMT

Qlikview script equivalent of SQL code

Oleg_Troyansky — Thu, 10 Mar 2011 01:47:35 GMT

In QlikView, you can do it in two steps - first, create a mapping table of all highest Seq. numbers. Then, load your data, comparing the sequence to the mapped values for each Personal ID.

Something along those lines:


Max_Seq_Map:
mapping load
DEGREE_PERSONAL_ID,
max(DEGREE_SEQ_NO) as Max_Degree
from ....
;
Degrees:
load * from ...
Where
DEGREE_SEQ_NO = ApplyMap('Max_Seq_Map', DEGREE_PERSONAL_ID, null())
;

Qlikview script equivalent of SQL code

Thu, 10 Mar 2011 09:40:37 GMT

Hi Oleg, do you know the script equivalent of this SQL, to get 3 Top values of each CategoryName?


SELECT Categories.CategoryName, Products.ProductName, Products.UnitsInStock
FROM Categories
INNER JOIN Products
ON Categories.CategoryID = Products.CategoryID
WHERE (((Products.UnitsInStock)
In (SELECT TOP 3 [UnitsInStock] FROM Products WHERE [CategoryID]=[Categories].[CategoryID]
ORDER BY [UnitsInStock] Desc)))
ORDER BY Categories.CategoryName, Products.UnitsInStock DESC;

Thanks!!