Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How do I create a caculated field with a result to show between a range of two numbers?

Hi community

I am trying to create a calculted field which shows only cost centres >= 9950 and <=9960.

1.     The total range of numbers available are 0000 to 9999

2.     The pivot table needs to show only cost centres including 9950-9960

3.     I have tried the following; CostCentreName >=9950 <=9960 but returns this message in the field '//Error in calculated dimension

Any ideas will be very much appreciated.

Andy

1 Solution

Accepted Solutions
Not applicable

Re: How do I create a caculated field with a result to show between a range of two numbers?

Aggr(only({<[Cost Centres] ={">=9950 <=9960"}>} [Cost Centres]),[Cost Centres])

2 Replies
Not applicable

Re: How do I create a caculated field with a result to show between a range of two numbers?

Aggr(only({<[Cost Centres] ={">=9950 <=9960"}>} [Cost Centres]),[Cost Centres])

Not applicable

Re: How do I create a caculated field with a result to show between a range of two numbers?

Thank you Kevincool. in time for me to get this sorted before I finish for the day.

Thanks again.

Community Browser