Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siva0606
Contributor III
Contributor III

Nested if condition with last 12 months calculation

Hi All,

I need to calculate one column with the below conditions using nested if statements in script.
Kindly help me on creating the below condition in script.

Start Date = '2018-10-01' 

Format = (year,month,date)

With value >=50                                                                                                                                        'A Category'

With value >=20 and <50                                                                                                                      'B Category'

With value >0 and <20                                                                                                                           'C Category'

With Value = 0 in Current 12 Months but have non zero values since Start date          'D Category'

With Value = 0 Since Start date                                                                                                          'E Category' 
 
as column name 

Kindly help me in calculating the above column.

Best Regards,

Siva

Labels (2)
1 Reply
siva0606
Contributor III
Contributor III
Author

Hi All,

Can someone help me on achieving the above column

Best Regards,

Siva