Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

ramya_beginner
Contributor

Help with Set Analysis

Hi

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!

4 Replies
Partner
Partner

Re: Help with Set Analysis

I believe it should be

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

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

ramya_beginner
Contributor

Re: Help with Set Analysis

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

ramya_beginner
Contributor

Re: Help with Set Analysis

I figured out ! Thanks

Re: Help with Set Analysis

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

Best,

Sunny