Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
eprehu
Contributor III
Contributor III

Aggr takes at least 2 parameters

Hello, 

I need help, i don't know where is the pb here  : 

eprehu_0-1655719149078.png

THanks.

 

Labels (1)
19 Replies
rubenmarin

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

eprehu
Contributor III
Contributor III
Author

Thanks, but i have no idea for this calculation

rubenmarin

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]

eprehu
Contributor III
Contributor III
Author

eprehu_0-1655729656935.png

i removed the aggr(), it doesn't work

eprehu
Contributor III
Contributor III
Author

eprehu_1-1655729770565.png

 

Or
MVP
MVP

The aggr() is still there, right on the top line... the inner one probably wasn't the problem.

rubenmarin

That's not the aggr to remove, I said the one with parenthesys in orange in your first screen capture

eprehu
Contributor III
Contributor III
Author

Thanks ! it is working. I only add the customer key at the end of the aggr()!!

 

Thanks a loooot!!!!!

rubenmarin

Try with option 2: add the dimension to aggr. Also maybe there is somenting in the _customerRepeat12Months variable