topic Re: Aggr() Function in QlikView

Aggr() Function

Fri, 22 Jun 2012 13:33:25 GMT

Hi Guys

Question

I have a Sheet in Qlik view qith a dropdown with Weeks. I need a expression that depending the Week selected in the dropdown I get the count of the days of the week. This should be grouped by Boss, Process and Week.

I tryied with this expression but I don't get any correct value.

Aggr (Count( {<Week={"&(=Week)"}>}Date) , Boss , Process , Week )

Any ideas?

Thanks in advance.

Re: Aggr() Function

swuehl — Fri, 22 Jun 2012 13:40:50 GMT

If you want to see your results grouped by Boss, Process, Week, create a straight table or pivot table chart with these dimensions. Then as expression maybe

=count({<Week = {'$(=max(Week)'}>} Date)

Hope this helps,

Stefan

Re: Aggr() Function

Fri, 22 Jun 2012 15:07:34 GMT

Thanks for your help this worked for me!

Count(Distinct{<Week={"$(=Week)"}>}Date)

Re: Aggr() Function

Fri, 22 Jun 2012 15:27:01 GMT

And this worked as well

Aggr(Count(DISTINCT{<Week={"$(=Week)"}>}Date),Boss,Process,Week)