topic Re: Top 10 Values in QlikView

Top 10 Values

Wed, 09 Jul 2014 23:18:31 GMT

I need to display the top ten values in a pivot chart based on the highest count.

The expression used is:=IF(date(INC_SUBMIT_DATE) > date($(vSliderDate)),count (DISTINCT INCIDENT_NUMBER))

where vSliderDate is the value that is given as an input from the user.

Re: Top 10 Values

Thu, 10 Jul 2014 00:02:42 GMT

can you try using the Dimension Limits tab?

Re: Top 10 Values

Thu, 10 Jul 2014 00:04:46 GMT

Pivot table doesnot have this tab

Re: Top 10 Values

Anonymous — Thu, 10 Jul 2014 02:01:01 GMT

Something like below,

In dimension,

Aggr(If(Rank(If(date(INC_SUBMIT_DATE) > date($(vSliderDate)),count (DISTINCT INCIDENT_NUMBER)))<=10, DIMENSION), DIMENSION)

Expression should be same as your above script.

PS: There might be a typo error in above script. You can follow below generic logic.

=Aggr(If(Rank(Sum(Expression))<=10,Dimension),Dimension)

Re: Re: Top 10 Values

jagan — Thu, 10 Jul 2014 02:04:12 GMT

Hi Anitha,

Please find attached file for solution.

Regards,

Jagan.

Re: Re: Top 10 Values

Thu, 10 Jul 2014 02:13:02 GMT

Did not find the attachment

Re: Top 10 Values

Thu, 10 Jul 2014 02:14:28 GMT

This is displaying the lowest 10 values not the top... I think its taking the least expression value as the first rank. I need to get the highest count to be the first rank

Re: Re: Re: Top 10 Values

jagan — Thu, 10 Jul 2014 02:36:00 GMT

Hi Anitha,

Please find attached file for solution.

Try like thi

Dimension: =if(aggr(rank(SUM(Sales),4,0), DimensionName)<=3,DimensionName)

Expression: =Sum(MeasureName)

Regards,

Jagan.

Re: Top 10 Values

Anonymous — Thu, 10 Jul 2014 02:55:01 GMT

Strange. Can you only use Rank function with expression and see what kind of rank you are getting? If possible share some sample qvw for fastest resolution.

Rank(If(date(INC_SUBMIT_DATE) > date($(vSliderDate)),count (DISTINCT INCIDENT_NUMBER)))