topic Re: Rank in Text Object in QlikView

Rank in Text Object

Mon, 25 Feb 2013 12:34:58 GMT

Hi all,

I have a text object where I want to display the top subcategory based on a count of respondents (for a survey).

I try the following function:

=IF(
                    RANK( TOTAL 
                    aggr( count( distinct ResponseID), subcategory)
  
                    , 4)
  
                              = 1
  
                                        , subcategory)

This gives me no (null) result. Does anyone know how to use the rank function in a text object in this way?

Thanks!

GPC

Re: Rank in Text Object

Mon, 25 Feb 2013 12:42:50 GMT

=IF(RANK(sum( TOTAL aggr( count( distinct ResponseID), subcategory)), 4) = 1 , subcategory)

Re: Rank in Text Object

Mon, 25 Feb 2013 13:02:01 GMT

Thanks for your response. Unfortunately I get the same result.

I can do a straight table with subcategory in the dimensions and use my original formula to get the subcategory that has the most respondents displayed.

However, when I remove the dimension of subcategory (as in a text object) then this no longer displays, I get null value.

Thanks

GPC

Re: Rank in Text Object

Mon, 25 Feb 2013 14:00:34 GMT

Hi ,

Try this expression in a Text object..

only({<subcategory= {"=rank(Count(distinct ResponseID),subcategory) =1"}>} subcategory )

Hope it helps you..

Thanks,

Bhaskar..

Re: Rank in Text Object

Mon, 25 Feb 2013 14:18:51 GMT

Brilliant, thanks so much!

Re: Rank in Text Object

Anonymous — Fri, 29 Aug 2014 06:17:46 GMT

Hi All,

I have defect table and displaying top3 defect owners name list in single text object.

Now I want to display top3 owners defect counts also in the same text object.

below one currently using for displaying owners name list,

Concat(IF(aggr(Rank(Sum(passed)),executedby)<=4,executedby & chr(10)))

IF ANYONE HAVE IDEA TO MODIFY THE ABOVE EXPRESSION,PLS SHARE

THANKS,

Prakash