Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

query from Access to Qlikview

I need to get something similar to this example of access, to obtein the 3 Top values of 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;


The spanish version is:

SELECT Categorías.NombreCategoría, Productos.NombreProducto, Productos.UnidadesEnExistencia
FROM Categorías INNER JOIN Productos ON Categorías.IdCategoría = Productos.IdCategoría
WHERE (((Productos.UnidadesEnExistencia) In (SELECT TOP 3 [UnidadesEnExistencia] FROM Productos WHERE [IdCategoría]=[Categorías].[IdCategoría] ORDER BY [UnidadesEnExistencia] Desc)))
ORDER BY Categorías.NombreCategoría, Productos.UnidadesEnExistencia DESC;


I need in to do it into load script but if anyone knows how to do it into set analysis will be usefull.

Thanks!

Labels (1)
0 Replies