Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody, hope somebody can help me. I'll try to explain what I want to achieve. I have a data set with the following structure:
What I need, is a pivot table that allows to do this:
I'm using the following expression to get the number of Total orders per employee regardless warehouse
AGGR(Count(OrderN), Employee)
And the following to the number of orders with weight between 20-50 kg per employee regardless warehouse
Count(if((aggr(sum(kg),OrderN)>=20)AND (aggr(sum(kg),OrderN)<=50),1))
but I get this result
Shouldn't repeat the values in the two rows? Maybe this can´t be done.
Hope someone can enligthen me.
Regards
The aggr() functions must include all the dimensions in the table:
=Count(if((aggr(sum(kg), OrderN, ....)>=20)AND (aggr(sum(kg), OrderN, .....)<=50),1))
For example:
=Count(if((aggr(sum(kg), OrderN, WAREHOUSE)>=20)AND (aggr(sum(kg), OrderN, WAREHOUSE)<=50),1))
The aggr() functions must include all the dimensions in the table:
=Count(if((aggr(sum(kg), OrderN, ....)>=20)AND (aggr(sum(kg), OrderN, .....)<=50),1))
For example:
=Count(if((aggr(sum(kg), OrderN, WAREHOUSE)>=20)AND (aggr(sum(kg), OrderN, WAREHOUSE)<=50),1))
Can you send sample qlikview file.
I think you handle this problem with total <Dimension> keyword.
Thank you both for your time. The solution is the combination of both answers.
Have a nice day