6 Replies Latest reply: Jul 10, 2017 9:10 AM by Todd Buss RSS

    formatting with Class function

    Todd Buss

      I have a range representing a count of days.  The functions below categorize them into 5 year segments for the X axis of a histogram. 

       

      this one works, but is incomplete:

      subfield(class(Days_to_TRD/365,5),' <= x < ',1) & '-'

       

      this one stops showing any values:

      subfield(class(Days_to_TRD/365,5),' <= x < ',1) & '-'& subfield(class(Days_to_TRD/365,5),' <= x < ',2)-1


      It's as if Qlik doesn't know how to define the buckets when more than one class statement is used.  Can anyone tell me what I'm doing wrong?

       

      Do I need to create the classes during the data load instead?