topic Re: What is Class function where we use give me an example in QlikView

What is Class function where we use give me an example

jonesbrown — Sat, 16 Nov 2024 19:33:29 GMT

Hi All

I am new to Qlikview

What is Class function where we use give me an example

plz help.

Re: What is Class function where we use give me an example

joseph_morales — Mon, 02 Dec 2019 03:35:14 GMT

Hello @jonesbrown

You can read the Qlik Help page. In the link you can find apart from the description of the function, also examples of how to use the function.

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ConditionalFunctions/class.htm

Re: What is Class function where we use give me an example

ramasaisaksoft — Mon, 02 Dec 2019 08:05:00 GMT

Hi ,

Class is alternative method to if to creates age or buckets. see below

class(expression, interval [ , label [ , offset ]])

Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'