Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Apply Map Question - Using a range of values

Hi

Is it possible to use the APPLY MAP function for a range of values?

The scenario i have is that i have a filed containing a number, this number relates to a duration (in days)

e.g. 1.032424

What I want to do is to categorise this duration into a banding, for instance '1 to 3 days'

So i want to take my original table, and create a new field for each row which states the band that each duration falls into

Duration Band

1.02323 1 to 3 days

0.5656 Less than 1 day

5.5353 3 days to 1 week

.... and so on

So the sort of mapping i need to carry out is dependent on the number range the duration falls in

< 1 maps to 'Less than 1 day'

>= 1 AND < 3 maps to '1 to 3 days'

Can this be done, my research suggests that an apply map is the tidiest way to do it, but the only examples i can find are exact mappings, and don't cater for ranges such as this.

Is this possible?

Thanks in advance

1 Solution

Accepted Solutions
Not applicable
Author

O.K!

Now you can open this version by personal edition without any problems.

We tested it some times and it was succesful.

Rainer

View solution in original post

4 Replies
Not applicable
Author

Hi,

please see if this example is helpful to slove your requirement.

Good luck!

Rainer

Not applicable
Author

Thanks Rainer, I'm still using the personal edition, so i guess i won't be able to open this without messing up my licence.. any chance you could copy and paste the bits of the script that do this in your example?

Cheers!

Matt

Not applicable
Author

O.K!

Now you can open this version by personal edition without any problems.

We tested it some times and it was succesful.

Rainer

Not applicable
Author

Perfect, thank you