topic Re: Display first 10 values in listbox in QlikView

Display first 10 values in listbox

Thu, 21 Nov 2013 08:59:56 GMT

Hi all,

Can we display in a listbox only first 10 values ?

Is this possible with macro ?

Thanks in advance

Re: Display first 10 values in listbox

tresB — Thu, 21 Nov 2013 09:03:42 GMT

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

update:

PFA

Re: Display first 10 values in listbox

Thu, 21 Nov 2013 09:26:55 GMT

you can bring from back end

Re: Re: Display first 10 values in listbox

manideep78 — Thu, 21 Nov 2013 10:36:59 GMT

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 ?

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

abeyphilip — Thu, 21 Nov 2013 10:59:19 GMT

Hi,

Please check if this helps.

Regards,

Abey

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

manideep78 — Thu, 21 Nov 2013 11:26:48 GMT

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.

Regards

Manideep

Re: Display first 10 values in listbox

israrkhan — Thu, 21 Nov 2013 11:35:01 GMT

Yes, its Possible,

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

Re: Display first 10 values in listbox

Anonymous — Thu, 21 Nov 2013 14:26:40 GMT

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.

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