topic Re: Set Analysis confusion in QlikView

Set Analysis confusion

Mon, 26 Jan 2026 18:19:17 GMT

I am not sure how to make this work, and i am sure there are some perfectly good logic to make this work but i cant seem to figure it out.So was hoping someone here in the Community coulde look at my example and explain to me what i need to do to make it show the correct data, preferably with a working example and why it work.

If you look in the Attached qvw i have created the a pivot table.

I got these basic Fields:

ShipmentID
Customer
SLA
Packages

I want the view to be as it is when i dont have any selections, but when i select a customer i want it only to show the shipments related to that customer. This "Works" now, but when i Select a customer the 'Total Packages' and '% Packages' Expressions is wrong.

How shoulde i use set analysis to make this work? or are there some other way to make this work?

-Lasse Rolstad

Re: Set Analysis confusion

Josh_Good — Wed, 07 Jan 2015 16:20:19 GMT

Hi Lasse,

There doesn't appear to be any data in your qvw. You can edit your post on the right hand side under the Action menu.

-Josh
Qlik

Re: Set Analysis confusion

Wed, 07 Jan 2015 16:30:24 GMT

Yes. sorry about that. I have uploaded the correct qvw.

Re: Set Analysis confusion

rubenmarin — Wed, 07 Jan 2015 16:39:09 GMT

Hi Lasse, please check attachment if this is what you want

Total expression: =If(not IsNull(Customer), sum(TOTAL <ShipmentID> {<Customer>} Packages))

% expression: (Sum(Packages)/sum(TOTAL <ShipmentID> {<Customer>} Packages))

Re: Set Analysis confusion

Wed, 07 Jan 2015 16:48:40 GMT

Yes that was exatly what i needed, i been trying for quite some time to get it to work.

Thank you, looks so easy when i read it now