Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

8 Replies
alexandros17
Partner
Partner

Yes, with the instructions Order by and Group By

VishalWaghole
Specialist II
Specialist II

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

Not applicable
Author

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

VishalWaghole
Specialist II
Specialist II

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
Master
Master

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
Contributor III
Contributor III

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

Not applicable
Author

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

VishalWaghole
Specialist II
Specialist II

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.