Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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))
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
Yes. sorry about that. I have uploaded the correct qvw.
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))
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