topic Re: Count Q1 & Q2 in QlikView

Count Q1 & Q2

knightwriter — Fri, 03 Jul 2015 15:00:32 GMT

Hi All,

Im looking to count Q1 and Q2 only as the total box changes when I select the month of May for example.

Any suggestions?

=count(distinct(if (InQuarter ([Activity.Completed Date], Today(), 0), [Activity Id], )))

Re: Count Q1 & Q2

MK_QSL — Fri, 03 Jul 2015 15:02:09 GMT

Kindly describe little more! Unable to understand about your requirement.

Re: Count Q1 & Q2

knightwriter — Fri, 03 Jul 2015 15:05:36 GMT

Is there a formula to count the number of activities for Jan to March and April to Jun.

I cannot use the month name in the formula as my month selection of my dashboard is based on dates.

Re: Count Q1 & Q2

swuehl — Fri, 03 Jul 2015 15:18:53 GMT

This will count activities of the previous quarter Apr-Jun:

=count(distinct(if (InQuarter ([Activity.Completed Date], Today(), -1), [Activity Id], )))

And this quarter before (Jan-Mar):

=count(distinct(if (InQuarter ([Activity.Completed Date], Today(), -2), [Activity Id], )))

Always with relation to today(). You may need to ignore selection in your date field:

=count({<DateField= >} distinct(if (InQuarter ([Activity.Completed Date], Today(), -1), [Activity Id], )))

Re: Count Q1 & Q2

knightwriter — Fri, 03 Jul 2015 15:36:53 GMT

OK thanks. I am having trouble combining 3 variables included in my formula as pre below, ie status = completed, in year 2015 and Q1. What am I doing wrong here? Thanks again

=count(distinct(if (QuarterName [Activity.Status]='Completed, Today(), -1), [Activity Id], )))

=Num (Count(Distinct If([Activity.Status]='Completed' AND InYear([Activity.Completed Date], Today(), 0), [Activity Id], )), '#,###')