Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am encountering problems in multiplying two quantities in a table box. My expression:
num([Share_HPPD%]*[Total Commit]) which returns null or zero.
What could be the possible problem and solution?
Make Sure your %Share values are in number format..At script level use num function on %Share field and then see if values are being calculated in chart.
Hi,
Try this:
Sum([Share_HPPD%])*Sum([Total Commit])
Make Sure your %Share values are in number format..At script level use num function on %Share field and then see if values are being calculated in chart.
I guess if you just use the fieldname as expression, you would still get null. And that would be possibly because there are more than one possible values in that data junction (in specific cell). And qlik would not show you multiple values or a result coming from multiple values in one cell unless you use any aggregation function (sum, concat, count.. ex.). Hope this helps.