Count if question

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I've got 2 separate questions here:

1) How do I adjust the expression below to give me a count of items that =1?

=count({$<Entity={'RNA'},[Reporting Date]={">=$(=Addmonths(max({1}[Reporting Date]),-5))"}>}aggr($(vColorIndex),[Reporting Month-Year],Entity))

2) The expression below gives me a count of items for the prior 6 months, how do I adjust it to give me the count for items 7-12 months ago? e.g. - for the 6 month period prior to the most recent 6 months. So if the most recent 6 months are July-Dec, I want to find the count for Jan-June.

Thanks!

Re: Count if question

vishsaggi — Mon, 23 Jul 2018 01:19:35 GMT

May be try this?

1.= Sum(Aggr(IF(count({$<Entity={'RNA'},[Reporting Date]={">=$(=Addmonths(max({1}[Reporting Date]),-5))"}>}aggr($(vColorIndex),[Reporting Month-Year],Entity)) = 1, 1,0), Entity))

2.
May be try this in your set

= count({$<Entity={'RNA'},[Reporting Date]={">=$(=Addmonths(max({1}[Reporting Date]),-12))<=$(=Addmonths(max({1}[Reporting Date]),-6))"}>}aggr($(vColorIndex),[Reporting Month-Year],Entity)

topic Re: Count if question in QlikView

Count if question

Re: Count if question