Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Adding rows pivot table

Post translated with Google Translate.

Please only post in English, unless you are posting in a language specific section.

---

Hello everyone,

                     I have the following problem. When I want to show the totalized a column in a pivot table, the total is wrong

the expression used is: = Count ({$ <Year = { '$ (vAñoAnterior)'}, Month =, Dia =>} DISTINCT ProductID)

Attached a picture of the pivot table.

Regards,

1 Reply
philipp_kunz
Contributor

Re: Adding rows pivot table

Hi try this,


= Count(aggr(Count ({$ <Year = { '$ (vAñoAnterior)'}, Month =, Dia =>} DISTINCT ProductID),Month,Dia))


Regards