Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner
Partner

using class function

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:

Untitled.png

please advise

I can walk on water when it freezes
1 Solution

Accepted Solutions
john_s_w_wood
Creator
Creator

Hello Ali

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

View solution in original post

6 Replies
anbu1984
Master III
Master III

Can you post sample app

john_s_w_wood
Creator
Creator

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
Creator
Creator

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

ali_hijazi
Partner
Partner
Author

yes it is a fact table column

I can walk on water when it freezes
john_s_w_wood
Creator
Creator

Ok. Ill try and send you an example shortly

john_s_w_wood
Creator
Creator

Hello Ali

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

View solution in original post