Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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!

Labels (3)
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!! 😀