topic Re: Interval in QlikView

Interval

michelivor — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Interval

sunny_talwar — Thu, 28 Dec 2017 00:38:10 GMT

May be using If statement in your dimension

Buckets

Re: Interval

michelivor — Thu, 28 Dec 2017 10:19:43 GMT

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

Re: Interval

sunny_talwar — Thu, 28 Dec 2017 12:14:38 GMT

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

Re: Interval

diego_a_barboza — Thu, 28 Dec 2017 13:34:30 GMT

Is it possible that you are referring to IntervalMatch?

Re: Interval

michelivor — Thu, 28 Dec 2017 19:45:01 GMT

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

Re: Interval

MarcoWedel — Thu, 28 Dec 2017 22:56:25 GMT

Hi,

maybe helpful (despite your intervalmatch doubts):

Custom Filter(unusual range)

regards

Marco

Re: Interval

MarcoWedel — Thu, 28 Dec 2017 23:43:21 GMT

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

Re: Interval

michelivor — Fri, 29 Dec 2017 15:41:28 GMT

Thanks Marco, appreciated...

Regards

Michel