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

Problem with calculated dimension (if and Sum)

bruno_silva100 — Thu, 30 May 2019 16:50:47 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)

rwunderlich — Thu, 30 May 2019 16:59:12 GMT

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

Re: Problem with calculated dimension (if and Sum)

nicu1996 — Thu, 30 May 2019 17:04:00 GMT

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.

Re: Problem with calculated dimension (if and Sum)

bruno_silva100 — Fri, 31 May 2019 11:49:01 GMT

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