Interval

[michelivor]

HI,

This is not about interval but something similar. I have a faint memory of a function in QV where you can group data in specific intervals. I don´t know if it is my memory playing tricks with me so please bare with me.

What I want to do is something like this:

Interval	Count
0-10	80
-100	40
-1000	20
-10000	10

n example of how many products I have in a certain price interval for instance.

I want to do this in an object/chart so IntervalMatch won´t work and the Class function has only fixed intervals.

I know I can do this in many different ways but is there a function for it in QV???

Brg

//Michel

[sunny_talwar · Accepted solution]

May be using If statement in your dimension

Buckets

[michelivor]

Hi Sunny,

I often use ValueList in this case or as you propose an If-statement. There are other ways as well.

The question how ever was more about are there a specific function to do this as Class but where you can create non-fixed intervals.

Reading Henric C. post it is clear there are no such functions, so thanks for your reply.

Brg

//Michel

[sunny_talwar]

Yes, you are right, there is no such function available in QlikView or Qlik Sense.

[diego_a_barboza]

Is it possible that you are referring to IntervalMatch?

[michelivor]

Hi Diego,

No, as I wrote i don´t want to use IntervalMatch in or to be more specific are there a variant of Class, but it wasn´t.

Brg

//Michel

[MarcoWedel]

Hi,

maybe helpful (despite your intervalmatch doubts):

Custom Filter(unusual range)

regards

Marco

[MarcoWedel]

one solution for this special case might be:

table1:
LOAD *,
    Dual(pow(10,Floor(log10(Value)))&'-'&pow(10,Floor(log10(Value))+1),Floor(log10(Value))) as Interval;
LOAD Round(pow(10,Rand()*5)) as Value
AutoGenerate 40;

hope this helps

regards

Marco

[michelivor]

Thanks Marco, appreciated...

Regards

Michel