topic Re: using class function in QlikView

using class function

ali_hijazi — Thu, 28 May 2015 14:11:37 GMT

Hello got a fact table against which I'm counting the number of regressions between two selected dates

my expression is as follows:

count

(DISTINCT

{

OFFICIAL=

,ROF_CATEGORY=

,TYPE={'reg'}

,RECORD_TYPE={'detection'}

,Year=

,MonthYear=

,Month=

,CALENDAR_DATE={'>= $(vFromDate) <=$(vToDate)'}

} ID

)

now what I want is to create a line chart that categorizes the above expression's result into brackets of 100 as length

I added a pivot table and added a dimension as follows:

=Class(TPK,100,'x')

and as expression the above expression yet I got the following:

please advise

anbu1984 — Thu, 28 May 2015 14:47:11 GMT

Can you post sample app

john_s_w_wood — Thu, 28 May 2015 14:51:16 GMT

Hello Ali

Is TPK a 'fact' value? You may need to use the aggr function eg aggr(nodistinct sum(TPK) , Yearorsomething)

john_s_w_wood — Thu, 28 May 2015 14:52:23 GMT

ie class( aggr(nodistinct sum(TPK) , Year),100,'x')

ali_hijazi — Thu, 28 May 2015 15:10:11 GMT

yes it is a fact table column

john_s_w_wood — Thu, 28 May 2015 17:27:25 GMT

Ok. Ill try and send you an example shortly

john_s_w_wood — Thu, 28 May 2015 17:46:49 GMT

Hello Ali

Heres an example using aggr and class. Hope the context is correct. KRegs John