topic Re: Class function in QlikView

Class function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Class function

maxgro — Mon, 21 Mar 2016 22:01:15 GMT

replace Year with your field

=Dual(

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

class(Year, 5, 'x')

)

Re: Class function

swuehl — Mon, 21 Mar 2016 22:06:47 GMT

Try something like

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

Re: Class function

Anonymous — Mon, 21 Mar 2016 22:08:32 GMT

MANY THANKS Maxgro that solved my problem

Re: Class function

Anonymous — Mon, 21 Mar 2016 22:15:11 GMT

Thank you Swuehl for your contribution