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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grouped dimensions

Hi All,

If I want to have last 7 days, 7-21days(for data entered in previous two weeks), >21days(data entered before 21 days) in the dimension axis for diplaying count of data, How can I get it?

Thanks

Labels (1)
2 Replies
Not applicable
Author

you could use a calculated dimension :

if(DATE > today()-7, '7 days',

if(DATE > today()-21, '7-21 days', '>21 days' ))

Not applicable
Author

Thanks!