Totals row doesn't show any value

[LDR]

Hi everyone,

I'm writing you because I'm trying to find the reason because one table object is not showing any value in the "Totals" row.

In my table all columns are master ítems with a specific set analysis  and all of them are showing data but totals are not calculated and I don't know the reason.

Maybe, is it necessary to include some formula for totals row?

Thanks in advance for your help

[rwunderlich]

It sounds like those measures won't calculate correctly without some dimension criteria. What happens if you put measure in a KPI object. Does it calculate?

-Rob

[LDR]

When I assigned one my measures to a KPI object it doesn't show any value. Maybe the reason is cause I calculated that master ítem with "if" sentence instead of "sum":

if ( Not WildMatch ([Part],'ABA.*')
and [Manufacturing Date] = (today(0) -1)
and [Machine] = 'M9987'
,SUM([Manufactured Quantity]))

Thanks

[tm_burgers]

Would it work to use the If Statement for your Dimensions in the table; and then use the measure SUM([Manufactured Quantity]) 

Dimension = 

if ( Not WildMatch([Part],'ABA.*')
and [Manufacturing Date] = (today(0) -1)
and [Machine] = 'M9987', [Dimension] )

Measure =

SUM([Manufactured Quantity]) 

[squeakie_pig · Accepted solution]

Because of the IF statement in the expression you might need to force the measure. Further down the measure details you should be able to choose a measure type (sum, count, avg etc)

[rwunderlich · Accepted solution]

I believe this should be written as Sum(If()):

SUM(
if ( Not WildMatch ([Part],'ABA.*')
  and [Manufacturing Date] = (today(0) -1)
  and [Machine] = 'M9987'
,[Manufactured Quantity]))

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

[LDR]

Thanks a lof for your answers they were very useful. 

Both of them work for me but I'm going to change my formula for master ítems measures putting IF statement inside SUM function.

Have a nice day

[Reynaldo]

You saved my life!!

Thanks,