topic Re: Selecting Ascending 5 Values in expression in QlikView

Selecting Ascending 5 Values in expression

Wed, 10 Jun 2015 10:44:04 GMT

HI Experts

In my Pivot table, Using a calculated Field Difference

Difference = ([last month Sales] - [Current month Sales])

now i want to choose on top 5 values by Ascending order

Please Suggest

Re: Selecting Ascending 5 Values in expression

prajapatiamar38 — Wed, 10 Jun 2015 10:56:53 GMT

Hi..

Try like this exp below using aggr():

=IF(Aggr(Rank(Sum(UnitPrice)),DivisionID)<=5,Sum(UnitPrice))

Try to modify this with your expression

Thanks

Re: Selecting Ascending 5 Values in expression

qlikmsg4u — Wed, 10 Jun 2015 11:09:51 GMT

It may be work

=Aggr(If(Rank(Sum(Sales)-Above(Sum(Sales)))<=5,Month),Month)

Re: Selecting Ascending 5 Values in expression

Kushal_Chawda — Wed, 10 Jun 2015 11:15:39 GMT

sum(aggr(if(rank(sum ([last month Sales]) - sum([Current month Sales]),4)<=5,sum ([last month Sales]) - sum([Current month Sales])), Dimension))

Re: Selecting Ascending 5 Values in expression

Wed, 10 Jun 2015 11:26:33 GMT

HI
I am using a Straight Table

Sorry Not using a Pivot table

Please Suggest

Re: Selecting Ascending 5 Values in expression

qlikmsg4u — Wed, 10 Jun 2015 11:30:40 GMT

Hi John,

Please try above responses, if they doesn't help your query, please post sample app

Re: Selecting Ascending 5 Values in expression

krishna20 — Wed, 10 Jun 2015 11:47:55 GMT

Hi,

why not you go for dimension limits option?

Re: Selecting Ascending 5 Values in expression

Anonymous — Wed, 10 Jun 2015 11:50:04 GMT

Hi John,

You can restrict Top 5 values in Dimensions Limits tab. Check it once. If it don't work out please upload sample app.

Re: Selecting Ascending 5 Values in expression

vijetas42 — Wed, 10 Jun 2015 12:10:53 GMT

Hi,

For that calculated expression you can set limit=top 5 from Dimension limit tab

Re: Selecting Ascending 5 Values in expression

avinashelite — Wed, 10 Jun 2015 12:17:14 GMT

Hi John,

You can try with Dimension limits in the chart properties or use the rank function .

Re: Selecting Ascending 5 Values in expression

Wed, 10 Jun 2015 12:21:53 GMT

HI QLIKmsg4u

Please find the attached QVW

there are 21 customers

sort is based on the field Difference Ascending

Now in this Straight table i want to show top 5 values for the field Difference

Re: Selecting Ascending 5 Values in expression

Wed, 10 Jun 2015 12:23:10 GMT

HI Avinash

Please find the attached QVW

there are 21 customers

sort is based on the field Difference Ascending

Now in this Straight table i want to show top 5 values for the field Difference

Re: Selecting Ascending 5 Values in expression

Wed, 10 Jun 2015 12:25:42 GMT

HI Vijeta

How can i do that for expressions in Dimension Limit

Sorry i am not clear

Re: Selecting Ascending 5 Values in expression

krishna20 — Wed, 10 Jun 2015 12:32:56 GMT

Hi,Try like this

Right click on straight table-> choose properties-> under properties Select Dimension Limits.Enable Restrict option .

Show only 5 or 10..what ever you need.

Re: Selecting Ascending 5 Values in expression

Wed, 10 Jun 2015 12:35:51 GMT

HI Krishna20

My Field Difference is an Calculated Expression not a dimension

Re: Selecting Ascending 5 Values in expression

krishna20 — Wed, 10 Jun 2015 12:45:31 GMT

Hi,

The below thread may clears your requirement.

Rank function in expression

Re: Selecting Ascending 5 Values in expression

krishna20 — Wed, 10 Jun 2015 12:56:07 GMT

Hi,

Please find the below attachment. Is this the your expected output?