How to calculate more months - Qlik Community

ptl14624 · ‎2020-03-04

Hi.

I want to create a measure or a dimension on a table,where one of the columns should be "starting date + 6 months"

I already tried the following formula, but no success.

=date(day([Starting Date])&(month([Starting Date])+6)&year([Starting Date]))

also, a want to insert a condition which says: this should only happen when Product Area is "PP".

Any ideas?

Thanks

Wlad_Masi · ‎2020-03-23

Hello @ptl14624 ,

Would the expression used in this thread achieve the result you are looking for?

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.