topic Re: using class function in QlikView

using class function

ali_hijazi — Wed, 16 Jul 2014 13:29:45 GMT

Hello

got a fact table that contains the defects reported by clients by date

I want to classify these clients for each release by brackets of number of defects reported by them

please advise on how to use Class function to get 3 brackets [0,5],[6,10],[11,...[

PradeepReddy — Wed, 16 Jul 2014 14:07:48 GMT

Generally...

Class( var,5 ) with var=7, will give the result ---> 5<=x<10

To convert this into brackets

'['&Subfield(Class(7,5 ) ,'<',1)&','&num(Subfield(Class(7,5 ) ,'<',3)-1)&']' will give the result as [5,9]

so you will get the result as.. [0,4],[5,9],[10,14].....

ali_hijazi — Wed, 16 Jul 2014 14:46:17 GMT

ok but I want to restrict brackets to only 3

but this way I need to calculate the count of defects by client in the script no?