optimize query with qvd

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the following query

with temp as(select distinct  [datecol],[Code Article],[Code Structure],[Code Site]
           from [Vente] t2
            where promo = 0
            and ([Code Article] is not null) and ([Code Structure] is not null) and ([Prix de Revient] is not null ))
select * from(
select distinct [datecol],[Code Article],[Code Structure],[Code Site],
      row_number() over(Partition by  [Code Article],[Code Structure],[Code Site] order by [datecol]desc ) as rn
      from temp
) d where   rn <= 28

How to do the same idea within QVD ?

Re: optimize query with qvd

settu_periasamy — Wed, 09 Mar 2016 15:21:42 GMT

Hi,

May be you can Load All the data using Select * , then you can limit the data using Load statement.

LOAD Distinct [datecol],
[Code Article],
[Code Structure],
[Code Site] Where rn<=28 Order by [datecol] desc;
SELECT * From YourTableName;

topic Re: optimize query with qvd in QlikView

optimize query with qvd

Re: optimize query with qvd