Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
I have been strugling with this one. I want to get the maximum monthly sales value per customer.
I've been using the aggr() function in QlikView and it worked perfectly, but when I apply it to Sense the app freezes. This is what I have: Max(aggr(sum(sales), customer, month))
Thanks in advance,
MEBG
Hello Ruben,
Yes, I'm using it in a table. The dimensions are: Month, customer and the measure should be the maximum monthly sales value. The result I'm looking for should be something like the image attached. So basically, I just want one value per month (max sales) and the name of the customer.
Thanks
Hi,
When you mention that the app freezes, what the is CPU/RAM usage of your computer/server? The formula looks fine and should do its work perfectly as you describe. Maybe you have a lot of customers? An AGGR() could be quiet heavy for you computer/server if you have a lot of rows.
Jordy
Climber
Hi,
Trying step by step:
If this works well, continue with the extra month dimension. If not, see where the problem starts occurring.
Jordy
Climber