Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
g23
Contributor III
Contributor III

Qlik Sense: How to aggregate variable values

Hello all, 

I'm a beginner of Qlik Sense and I need to aggregate the values of a variable. 

My variable goes from 0 to 365 , and I need to create a variable that aggregates the values into 30, 90 and 365 days.  

 

 

Capture.PNG

It would be appreciated if anyone can give me some suggestions.

Thanks!

2 Replies
OmarBenSalem

Go to the script where u have this field:

 

if(YourField<=30,'30', if(YourField<=60,'60','365')) as NewField

g23
Contributor III
Contributor III
Author

Thank you!! 😀