topic How to calculate Mode() without 0 in QlikView

How to calculate Mode() without 0

Wed, 16 Jun 2010 17:57:40 GMT

Hi Everybody

I want to have the mode of a field without 0.

This is an example for what i want to have:

Price:

If i use Mode(price), the result will be 0.

The result that i want will be 15.

I'm awaiting for any help.

Regards

lblancher — Wed, 16 Jun 2010 18:35:27 GMT

Hi Jeff,

You could try Mode(if(Price <> 0,Price)), and see if you get the result that you are looking for.

Lucas

BizXcel Inc.

Wed, 16 Jun 2010 20:01:57 GMT

Ifs are nasty memory hogs, and should be avoided if possible, especially on large datasets.

I would use set analysis.



=
mode({$<QUANTITY = -{0}>} QUANTITY)

Thu, 17 Jun 2010 10:12:48 GMT

Thanks Lucas,

I try it and it works.

Many Thanks