Listbox

[dolly777]

Hi All,

I have list box i want see 1000 records  after reload the QVW. but don't use in script in first 1000.

How can i do ...........

Thanks&Regards:

Dolly

[MK_QSL]

Something Like below to write in List Box Expression...

=IF(Aggr(RANK(SUM(Sales)),[Customer Name])<=1000,[Customer Name])

[#3]

You can use RANK function as follows:

=if(aggr(rank(AMOUNT),AMOUNT) <=1000 ,AMOUNT)

THanks,

Angad

[dolly777]

Hi Manish,

It's working fine Thank u so much.

[MK_QSL]

Please close the thread by selection appropriate answer..

Thanks...

UPDATE : Please close this thread..