Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Display first 10 values in listbox

Hi all,

Can we display in a listbox only first 10 values ?

Is this possible with macro ?

Thanks in advance

7 Replies
Highlighted
MVP
MVP

Re: Display first 10 values in listbox

Macro would not be required. Using rank, aggr functions would get you there.

update:

PFA

Highlighted
Not applicable

Re: Display first 10 values in listbox

you can bring from back end


Highlighted
Partner
Partner

Re: Re: Display first 10 values in listbox

Hi,

Please find the attached app, In the expression if given as <=3 means then the output should come as a,b,c how we can get this ?

Highlighted
Creator II
Creator II

Re: Re: Re: Display first 10 values in listbox

Hi,

Please check if this helps.

Regards,

Abey

Highlighted
Partner
Partner

Re: Re: Re: Re: Display first 10 values in listbox

Hi,

This is good. I have one more problem.

Instead of text or Numeric values I'll show Images in the List box. All my Images are in another server and all my Urls in local machine.

There exist a case like even though the Image is not present in server, there will be a Url in my local Machine. So, for a URL the Image may or may not exist.

So, when I show Images in List box, It gives images where exists but giving white colored cells for those not having images, But not treating as null or empty cells.

How can I show a message like "No Image" if there is no image exist.

I appreciate your help. Thanks in advance.

Capture.jpg

Regards

Manideep

Highlighted
Specialist II
Specialist II

Re: Display first 10 values in listbox

Yes, its Possible,

but on what condition, i mean which 10 you want to get, first 10, last 10, or any other condition.

Highlighted
Contributor III
Contributor III

Re: Display first 10 values in listbox

Hi All,

It is possible working with functions of aggregation and ranking, like this example embedded in message.

In this example, we can obtain the three best sellers from a simple table with name of seller and his total of sales.

vendas.png

Total of sales grouped by SalesMan: =Aggr( Sum(SalesAmount), SalesMan )

Ranking of Sales: =rank(Aggr( Sum(SalesAmount), SalesMan ))

Combining these features we have 3 best sellers:

     =if(

         aggr( rank(sum(SalesAmount)), SalesMan ) <= 3,

         aggr( rank(sum(SalesAmount)), SalesMan ) & ': ' & SalesMan

         )

Evandro Segura

from Brazil