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

Projects expiring 3,6,9 months

I have two fields 'Project_Name' and 'Project_Expiry'. How do I show projects expiring within the next 3, 6, and 9 months ?

Thanks in advance

11 Replies
Digvijay_Singh

In which chart you are using this, it works on text box, need to see where you are using it to understand the problem.

Not applicable
Author

I get an error in calculation. I believe this is because you can not use group functions directly in calculated dimension.

If I wanted to add this as an expression instead what should it look like ?