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?

[yogiachilleos]

Howdy Bruno,

What’s the problem? Are you not getting the expected dimension? You may want to use an aggr if your sum is dependent on a dimension not listed in the table. You could also try replacing your single quotes with [ and ] enclosures. 

Hope that helps!

Kind regards,

Yogi Achilleos 

[bruno_silva100 · Accepted solution]

Tks @yogiachilleos , I don't know why this topic duplicate, but i resolved in this topic.

https://community.qlik.com/t5/Qlik-Sense-App-Development/Problem-with-calculated-dimension-if-and-Su...

Tks for attention