topic problem with listbox selection in QlikView

problem with listbox selection

Wed, 18 Feb 2015 01:39:16 GMT

hi,

i have table which i have linked to a listbox. if i dont select anything from the listbox then all the data are accurate. however if i select a division from the list box, in the 3rd column the sum of all division shows instead of showing the sum only for that division. if i clear the selection the relavant sum shows up correct. so i believe i am missing something.

attaching the file for refrence.

Re: problem with listbox selection

sunny_talwar — Wed, 18 Feb 2015 02:40:03 GMT

Please check if this is what you were trying to accomplish. PFA

Best,

Re: problem with listbox selection

rwunderlich — Wed, 18 Feb 2015 02:44:10 GMT

A good way to debug this is to put each of the components into separate columns. You'll see that the sum(Resource) is the same for all Divisions except ADN. So when you filter to a Division it's 1/1*Resource and you get the same answer.

I think what you want is to consider all the Divisions in your TOTAL divisor. Add a set modifier to ignore DIvision selections.

=Sum([Time to complete])/Sum({<Division=>}Total [Time to complete])*Sum(Resource)

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: problem with listbox selection

Wed, 18 Feb 2015 02:49:06 GMT

thanks a ton buddy...it worked