Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need help, i don't know where is the pb here :
THanks.
Hi, aggr does an expression for each value of a dimension(s), so you need the expression and at least one dimension.
https://help.qlik.com/es-ES/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/aggr.htm
Thanks, but i have no idea for this calculation
In the screen capture there are two parenthesys in orange, one starts the aggr() and the other closes it, so you have to options:
- Remove Aggr()
- Add a dimension before closing the parenthesys, it looks like the dimension could be [Customer Key] or something that groups different [Customer Key]
i removed the aggr(), it doesn't work
The aggr() is still there, right on the top line... the inner one probably wasn't the problem.
That's not the aggr to remove, I said the one with parenthesys in orange in your first screen capture
Thanks ! it is working. I only add the customer key at the end of the aggr()!!
Thanks a loooot!!!!!
Try with option 2: add the dimension to aggr. Also maybe there is somenting in the _customerRepeat12Months variable