Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
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
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
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])
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)
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
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
You saved my life!!
Thanks,