topic Re: Manually class enter in QlikView

Manually class enter

Fri, 02 Jan 2015 08:34:00 GMT

I am using this calculated dimension i want to make it manually and make ranges 0-5, 5-10 and if user enter 15 then 0-15,15-30 by input.

How can it be

=Replace(Class(ID,10),'<= x <', '-')

Jay

its_anandrjs — Fri, 02 Jan 2015 08:36:23 GMT

Then create a variable vNumEnter and use it in the expression

=Replace(Class(ID,vNumEnter),'<= x <', '-')

And also use this variable in any input box for number enter.

Regards

Anand

Anonymous — Fri, 02 Jan 2015 08:47:04 GMT

Hola!

Create buckets in the backend.Perhaps, that will meet your req.

HTH.

Anonymous — Fri, 02 Jan 2015 08:54:26 GMT

Use the if condition instead of class function

If(ID <5,'0-5',

If(ID >5 and ID <10 ,'5-10',

If(ID >10 and ID <15 ,'10-15',

If(ID >15 and ID <20 ,'15-20','Above 20'))))