topic Re: InQuarter Count in QlikView

InQuarter Count

knightwriter — Tue, 12 Jan 2016 16:50:42 GMT

Hi all,

I have discussed previously the issues I was encountering for my InQuarter count and I thought it maybe be easier to start fresh.

I am looking to count the number of activities by quarter depending on the what Year the user has selected. I am using 2015 & 2016 data only and cannot get it to change result when the year selected changes. Below is what I am currently using. Many thanks.

=(Count(Distinct If ( [Activity.Status]='Completed' AND InQuarter([Activity.Completed Date], Yearstart(Today()), 0), [Activity Id], )

Re: InQuarter Count

sunny_talwar — Tue, 12 Jan 2016 17:13:43 GMT

Which Quarter's value would you like to see here? Quarter 1 or all Quarters?

Re: InQuarter Count

knightwriter — Tue, 12 Jan 2016 17:40:16 GMT

Hi Sunny,

I would like 4 separate List Box Properties - one for Q1, a second for Q2 etc

Re: InQuarter Count

maheshkuttappa — Tue, 12 Jan 2016 18:00:08 GMT

Could you share sample data ?

Re: InQuarter Count

knightwriter — Wed, 13 Jan 2016 11:14:34 GMT

Does this make sense? Or should I take a different approach?

As per sample below.

Re: InQuarter Count

avinashelite — Wed, 13 Jan 2016 11:40:02 GMT

may i know why your using the Yearstart in your expression because it always starts your date with the 01-01 for that year so it always corresponds to that particular Quarter or Q1. could you please elaborate bit more on this