is there sorting is possible in qlikview while loading data from database? is grouping is also possible?

[#1]

is there sorting is possible in qlikview while loading data from database? is grouping is also possible?

[alexandros17]

Yes, with the instructions Order by and Group By

[VishalWaghole]

Sorting is not possible while loading data into QlikView,

but with resident load you can do sorting.

Resident load is load the existing data so sorting is possible with them,

but for ordinary load there is no data for comparison that's why sorting is not possible.

Hope you understand.

-- Regards,

Vishal Waghole

[#4]

in sql it is poosible right?why not in qlikview?

[VishalWaghole]

Sql calculate it from database,

QlikView need some data in RAM, when you load first time them Data will comes into RAM, once data came,

then you can sort it by using order by with Resident load.

-- Regards,

Vishal Waghole

[sasikanth]

While loading the data from DB , qlikview will store the as it is,,

if you want to sort any thing , then go for resident load and then delete the main table

[umerikhlas]

If you are loading data from SQL Server then Order By can be used as follows:

Orders:

LOAD

CustomerID,

EmployeeID,

Freight,

OrderDate,

OrderID,

OrderID AS OrderIDCounter,

ShipperID

;

SQL SELECT *

FROM Orders ORDER BY OrderDate ASC;

Hope this helps..

Thanks & Regards

[#8]

if i write condition while loading data in to qlikview? it work ? reason pls

[VishalWaghole]

Think it this way:

Suppose, you are requested to arrange a few names alphabetically. Now I give you names one by one. When you get the first name you can't put it in an arranged way because you don't have the reference to compare the name with; where you should place that name. The arrangement approach is only be possible when you know/have all the names. Similarly, qlikview loading records are like getting data one by one. So qlikview would only be able to sort them when all values are loaded/available in the memory.

I guess, alternate could have been possible, but that could be costly in terms of memory utilization, hence QlikView avoids that.

hope this helps.