Help with Group by or Aggregation

[davyqliks]

Hi Experts,

I could really do with a little more of your assistance please.

Here is my load expression from the script:

Load *,
if(wildmatch (Part, 'Shell Fabric' ),Sum([Shell Weight]/100 * Percentage ))as [Weight Breakdown]

from
[lib://Qlik Sense E Drive/Live/QVD's/MasterData.QVD](QVD)
group by "Portal Order No."
;

I hope you can see i am trying to get the shell weight / 100 and multiplied by the number in the percentage field but grouped by the main field "Portal Order no".

There is no syntax error but when i try to load i get the following.

I hope someone can assist in grouping this sum by the field Portal Order No.

Thank you so much for your time in advance.

Daniel

[davyqliks]

Hi All.

alternatively,

Is there a way to fix this measure of a pie chart to only look at the field "Portal Order No"

Sum(

if(wildmatch (Part, 'Shell Fabric' ),([Shell Weight]/100) * Percentage,

if(wildmatch (Part, 'Lining' ),([Lining Weight]/100) * Percentage,

if(wildmatch (Part, 'Padding' ),([Padding Weight]/100) * Percentage,

if(not wildmatch (Part, 'Padding','Shell Fabric','Lining' ),([Other Weight]/100) * Percentage

)))))

Thanks again in advance for any assistance you might be able to offer.

Daniel