topic Re: Problem with calculated dimension (IF and Sum) in App Development

Problem with calculated dimension (IF and Sum)

bruno_silva100 — Wed, 22 Dec 2021 19:09:11 GMT

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?

Re: Problem with calculated dimension (IF and Sum)

yogiachilleos — Thu, 30 May 2019 22:20:42 GMT

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

Re: Problem with calculated dimension (IF and Sum)

bruno_silva100 — Fri, 31 May 2019 11:43:37 GMT

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-Sum/m-p/1586768#M42941

Tks for attention