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: 
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