topic Re: Help with Set Analysis in QlikView

Help with Set Analysis

Anonymous — Mon, 06 Jun 2016 22:36:32 GMT

I am trying to write an expression where Status = Open and Clndr_Dt is less than or equal to Previous then count Jirakey and

where Status = Closed and Resolution Date is greater than Previous date , I want the combined count of jirakeys for both these condition , but the below expression does not give me right results is there anything wrong in the expression below?

=count ({$<CLNDR_DT={'$(<=vPreviousDate)'},Status={'Open'}> *
<[Resolution Date]={'$(>=vPreviousDate)'},Status={'Closed'}>}[Jira Key])

Thanks!

Re: Help with Set Analysis

alexdataiq — Mon, 06 Jun 2016 22:49:46 GMT

I believe it should be

=Count ({$<CLNDR_DT={"<=$(=vPreviousDate)"},Status={'Open'}>}[Jira Key]) +

Count({<[Resolution Date]={">=$(=vPreviousDate)"},Status={'Closed'}>}[Jira Key])

Re: Help with Set Analysis

Anonymous — Mon, 06 Jun 2016 23:35:00 GMT

Please find the attached application , I have created 2 expressions Open and Close .. I need to Combine these 2 expression into One ,

Another problem I am having is I want the Closed expression to be > than previous date NOT greter than or equal to .. but when ever I remove = sign I get zero

so my final out expression should be 48 ( Open)+ 5 (Closed) = 53 , as the previous date in 5/27

Re: Help with Set Analysis

Anonymous — Tue, 07 Jun 2016 00:01:17 GMT

I figured out ! Thanks

Re: Help with Set Analysis

sunny_talwar — Tue, 07 Jun 2016 00:08:15 GMT

If you got what you were looking for, please close this thread by marking the correct and helpful responses.

Best,

Sunny