topic Choosing Max 200 in Expression in QlikView

Choosing Max 200 in Expression

Fri, 29 May 2015 07:39:22 GMT

Hi Experts

I have an Calculated Expression in a straight Table [Last Month sale] - [Current month sale]

Now I want to choose only top 200 values based on my Customer Number dimension

Please Suggest

Re: Choosing Max 200 in Expression

PrashantSangle — Fri, 29 May 2015 07:43:32 GMT

Hi,

In Straight table->property->Dimension Limit->Restrict data->Show Largest enter 200

You can use Rank() also.

Regards

Re: Choosing Max 200 in Expression

prajapatiamar38 — Fri, 29 May 2015 07:46:14 GMT

Hi...

Try like this expression.

=IF(Aggr(Rank([Last Month sale] - [Current month sale]),CustomerNo)<=200,([Last Month sale] - [Current month sale] ))

I hope this will help you

Thanks

Re: Choosing Max 200 in Expression

Fri, 29 May 2015 07:48:21 GMT

HI Max

I am calculating Drift the formula for that is [Last Month sale] - [Current month sale]

So i want Max 200 in Drift

Re: Choosing Max 200 in Expression

Anonymous — Fri, 29 May 2015 07:50:34 GMT

Hi,

You can do this using Dimension Limits. First sort your expression and make sure your expression is given the first priority. Then go to Dimension Limits tab and select Largest 200.

Re: Choosing Max 200 in Expression

Fri, 29 May 2015 07:51:08 GMT

HI Amarnath I am getting Null Values for all

Re: Choosing Max 200 in Expression

IAMDV — Fri, 29 May 2015 07:51:12 GMT

Is [Last Month sale] and [Current month sale] fields or expressions?

Re: Choosing Max 200 in Expression

PrashantSangle — Fri, 29 May 2015 07:51:29 GMT

Hi,

You want top 200 Customer Number which have max drift

Then try my earlier solution or you can also try Amarnath Solution.

Regards

Re: Choosing Max 200 in Expression

Fri, 29 May 2015 07:56:18 GMT

HI Deepak

[Last Month sale] is a Calculated Field

[Current month sale] is also a Calculated Field

Now I want to Calculate another field Drift

the formula for that is [Last Month sale] - [Current month sale]

Re: Choosing Max 200 in Expression

Fri, 29 May 2015 07:57:27 GMT

Hi Max I tried it

But not able to get the desired result

Re: Choosing Max 200 in Expression

prajapatiamar38 — Fri, 29 May 2015 07:57:32 GMT

Hello,

As you said you are using Drift so you can simply write Drift in place of the [Last Month sale] - [Current month sale].

Thanks