QlikView App Dev

[Anonymous]

I have the following chart:

Instead of having classes like 1970 - 1975, 1975 - 1980, 1980 - 1985 can this be changed to 1970 - 1974, 1975 - 1979, 1980 - 1985 which would be more meaningful than what the default class function provides.  I am using the following;

Regards

Chris

[maxgro · Accepted solution]

replace Year with your field

=Dual(

  subfield(class(Year, 5, 'x'), '<', 1) & ' - ' & (subfield(class(Year, 5, 'x'), '<', 1)+4)

  , 

  class(Year, 5, 'x')

  )

[swuehl]

Try something like

=Dual( floor(YearField,5,0) & '-' &Ceil(YearField,5,4), Floor(YearField,5,0) )

[Anonymous]

MANY THANKS Maxgro that solved my problem

[Anonymous]

Thank you Swuehl for your contribution