topic Re: Create a dimension with sales range in QlikView

Create a dimension with sales range

manozpph — Tue, 02 Sep 2014 05:44:01 GMT

I need to Create a dimension with sales range between

a. 0<= Sales < 5,000

b. 5,000 <= Sales <10,000 etc

Can Some one help me to write a condition on Sales.

Thanks in Advance,

ashfaq_haseeb — Tue, 02 Sep 2014 05:45:23 GMT

Hi,

You need to use class() function

Regards

ASHFAQ

Tue, 02 Sep 2014 06:54:46 GMT

Hi,

Use Class function like this

Dimension=Class(Sales,5000,'Sales',0)

Regards,

Vivek

jagan — Tue, 02 Sep 2014 07:06:43 GMT

Hi,

Check this link hope it helps you.

Regards,

Jagan.

MayilVahanan — Tue, 02 Sep 2014 07:12:30 GMT

Class function satisfy ur requirement.

Try something like this

Class(Sales,5000,'Sales')