Comparison in table/pivot

[Morcella]

Hi Everyone,

I faced a challange in my lastest app. The expected format that the requestor wants is something like this (dummy data):

I thought table or pivot will give me the solution (Product and Issue type can be next to each other), but in pivot the Issue type divides the produced amount so I have it like the produced amount is 75 and the Paint error is 75 so the Issue share is always 100%.

Is there any solution for a visualization like this? There are many Products and Issues, I cannot solve it in my data source.

Thanks,

Morcella

[Antoine04]

Hello,

Which version of Qlik are you using ?

Is it Qlik Cloud ?

Regards,

Antoine

[JonnyPoole · Accepted solution]

What is your expression for "Produced Amount"?  

If its Sum([Produced Amount])  you can change it to do a sub total against another field in the same table like this:

Sum( <Product Type> [Produced Amount] ) 

This will sum up across all issue types and give you one total value for produced amount for each unique product type. 

[Morcella]

Thanks a lot! It seems like I was too focused on table/pivot format, and didn't think about using another formula.

It worked for me with Total: Sum( Total <Product type> [Produced Amount] )