Problem with calculated dimension (if and Sum)

[bruno_silva100]

Hello,

I have a problem when a tried to create a dimension calculated.

=if(Sum([Qtde Vendida])=0,'Sem Movimento','Com Movimento')

Does anyone know what happens in this case?

[rwunderlich]

Are  you are trying to create a single or multiple dimension value. If multiple,  you must specify what dimension you are summing over using aggr. For example, by Month -- to generate 'Sem Movimento'  or 'Com Movimento' for each Month:

aggr( if(Sum([Qtde Vendida])=0,'Sem Movimento','Com Movimento'), Month)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[nicu1996]

If you want to use an aggregation function, you have to add your expression as a measure (Then, choose None as Totals function).

As a Field/Dimension, it is not working fine.

[bruno_silva100 · Accepted solution]

Tks Rob and Nicu1966, but I changed the dimension and it worked. For this case i didn't have the paremeter for to use aggr