topic Re: What does this expression do? in QlikView

What does this expression do?

qlikviewwizard — Fri, 20 Nov 2020 18:02:30 GMT

Hi All,

What does this expression do? Thanks in advance.

replace(Class(Age,5), '<= x <','-') as GroupAge,

qlikviewwizard — Sun, 19 Jul 2015 14:14:32 GMT

Please explain and give an example.

maxgro — Sun, 19 Jul 2015 14:24:29 GMT

explain in yellow and bold in script

tmp:

load

RowNo() as People,

floor(rand()*100) as Age

AutoGenerate 100;

load

replace(Class(Age,5), '<= x <','-') as GroupAge,

Class(Age,5) as GroupAge2

Resident tmp;

DROP Table tmp;

qlikviewwizard — Sun, 19 Jul 2015 14:29:03 GMT

Hi maxgro

Thank you so much. I got it.

jagan — Mon, 20 Jul 2015 00:32:56 GMT

Hi,

Class() is used to group the values with the specified ranges or called it as Buckets.

replace(Class(Age,5), '<= x <','-') as GroupAge

The above script creates the age group with the interval of 5, when you do this you will the format like

5 <= x < 10 to remove the symbols between the we use the Replace().

HOpe this helps you.

Regards,

Jagan.

qlikviewwizard — Mon, 20 Jul 2015 04:48:35 GMT

Hi jagan

Thank you for detail explanation.