Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a department A,B,C,D—I have sales- department wise sales. A has sub departments, which has made sales. Similar to all the departments. I want to get the top 2 sub departments that has highest sales.
Sujit, little confused here, as this is QlikView forum, not SQL Server, so if you are looking for help on SQL query, I would hit the Microsoft Community for SQL Server. If you are looking for how to do something in QlikView you do in SQL Server, then you may be in the right place, but we are going to need some further details in order to try to help here. You need to provide as much detail as possible if you want to get responses from folks, the more information the better including the underlying use case etc. and sample data is helpful as well.
Regards,
Brett