Aggr() Function

[#1]

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.

[swuehl]

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

[#3 · Accepted solution]

Thanks for your help this worked for me!

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

[#4]

And this worked as well

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