Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
siva_boggarapu
Creator II
Creator II

Make Intervals based on field values

Hi Everyone,

I have Date filed like below mentioned format

Date:

1.75 (1 year 7 months)

3.50  (3year 5 month)

9.25

10.50

11.00

 

I need output like below  based on above data

0 -1 years

1 - 2 years

2-  3 years

3 -4 years

......

 

Please help me how to get this 

Regards,

Siva

 

 

 

 

 

 

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

As below

 

temp:
Load interval_yy,replace(class(interval_yy,1),'<= x <','-')&' years' as group inline [
interval_yy
1.75
3.5
9.25
10.5
11
]
;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

As below

 

temp:
Load interval_yy,replace(class(interval_yy,1),'<= x <','-')&' years' as group inline [
interval_yy
1.75
3.5
9.25
10.5
11
]
;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.