Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hello,
Which version of Qlik are you using ?
Is it Qlik Cloud ?
Regards,
Antoine
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.
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] )