month to month year prior.

[dries_clairhout]

Hello everyone,

For a Client of mine we set up a Activity analysis sheet for the warehoue.

Now the client wants to see the activities of the personel of the month compared to the month year prior.

This is in Qlik Sense,

I did this formula.

=avg(aggr(sum({<Month= = {"=$(=Max(Month))"} ($(vColli))/$(vDag), Datum, magazijnier))

But it doesn't display anything.

The normal formula (displays based on selection):

=avg(aggr(sum($(vColli))/$(vDag), Datum, magazijnier))

Explenation fields:

Datum (Date)

Magazijnier (employee)

vDag (Day)

vColli (parcel)

Thanks in advance.

[dries_clairhout]

Hello,

I want to upload a qvf but I get this error:

Thanks in advance

Dries

[sunny_talwar]

You will need to zip the qvf file before you can attach.

[dries_clairhout]

Hello,

Here you go,

have a look.

have fun 😉

thanks in advance

[sunny_talwar]

Which tab am I looking at and what is the expected output that we are looking to get?

[dries_clairhout]

Hello,

So in the dashboard on the bottom you have averages per person.

These averages should come in a different tab (comparisson sheet).

client wants:

1) Month to Month prior comparisson of these graphs

2) Month to Month year prior 

3) Year to year

thanks in advance,

Dries