Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

zwyne
Contributor

Current monthstart date going back 30 days ago

Hi everyone,

PFA

I have question to ask you. On the attached sample data, I have got 3 fields. I have the following conditions: 

Issue Priority = 'Major' and  Issue Status = 'Pipeline' .So what I want to calculate is count the number of the previous condition when the  Date = '2018-10-01' and then from the Issue Creation Date check the difference of 30 days. 

i.e. Date -  Issue Creation Date (2018-09-01). So give me the number of these and in this case = 1.

So assist with this.

Thanks

 

 

 

1 Solution

Accepted Solutions
zwyne
Contributor

Re: Current monthstart date going back 30 days ago

I managed to get it correct. Thank you
1 Reply
zwyne
Contributor

Re: Current monthstart date going back 30 days ago

I managed to get it correct. Thank you