topic Re: DISTINCT COUNT Not Rolling to Quarters in QlikView

DISTINCT COUNT Not Rolling to Quarters

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

Hi,

I have Wrote Below Expression for one of my report but its not rolling to Quarters

=count({$<[NumValue]={1}>}distinct([Project ID]))

for example Nov =10

Dec=10

Jan=10

Its not showing 30 in Quarter.

Can some help guide me here

Re: DISTINCT COUNT Not Rolling to Quarters

sunny_talwar — Thu, 17 Jan 2019 17:20:32 GMT

What is it showing when you use the expression?

Re: DISTINCT COUNT Not Rolling to Quarters

dunnalahk123 — Thu, 17 Jan 2019 17:59:53 GMT

Hi Sunny,

Thank you so much for your response.

example i have given.

I guess what happening here is

if we have project ID in Nov and Same Project ID it is in Dec and Jan when it rolls to quarter it is counting only once.

Re: DISTINCT COUNT Not Rolling to Quarters

sunny_talwar — Thu, 17 Jan 2019 18:02:33 GMT

You want to count it 3 times? Try this

Sum(Aggr(Count({$<[NumValue] = {1}>} DISTINCT [Project ID]), MonthField))

Re: DISTINCT COUNT Not Rolling to Quarters

dunnalahk123 — Thu, 17 Jan 2019 18:42:33 GMT

Hi Sunny,

Thanks a lot Sunny.

It working 🙂 but when i am adding in Chart and all i think i have to add what all Dimensions i am using in my report i have to add along with monthField.

once again thank you so much For your time .