Hi, I have a need to be able to to the following in an existing QlikView model 1. In invoice transactions where a document includes a specific itemcode, return the sales values for the complete document. 2. I do not have access to the script so this will need to be done in a chart in the front end Is this something that you could assist with please?
you can do it in set analysis have you tried following ?
sum ( {< Itemcode = {'TRA04'} >}Sales)
Thanks
Vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
