Class()

n1ef5ng1 — Mon, 27 Jan 2014 06:54:28 GMT

Hi I am using this function call Class where it will categorize the value into groups

say if my value output is 0 4 5 6 7 8 8 8 9 10 30

It will categorize to

0-3 -- 1

4-6 -- 3

7-9 -- 5

etc

using the function class(value,3)

However my value do contain negative such as -4 -7 -12 0 4 5 6 7 8 8 8 9 10 30

I would like all the negative to categorize to 0 and the rest will be 1-3 etc etc. how can this be done? i tried using this expression but it group all the negative to 0-3

if(Tranship_Dwell < 0,'0',

Class(ceil(ceil(Tranship_Dwell/1440)) ,$(var_Dwell)))

Re: Class()

n1ef5ng1 — Mon, 27 Jan 2014 07:09:18 GMT

Solved

if(Tranship_Dwell < 0,'0',
Class(ceil(ceil(Tranship_Dwell/1440)) ,'5','x','1'))

Re: Class()

nagasekhar — Fri, 15 Oct 2021 16:30:54 GMT

1. what is this 1440

2.why you typed '5','x','1'

what is the meaning of this

topic Re: Class() in QlikView

Class()

Re: Class()

Re: Class()