Need to ignore filter and not exclude

[#1]

I have a data set as below:

Region     Value     sum(Value)/Sum(Total(Value))

A     5000     5000/18000

B     6000     6000/18000

C     7000     7000/18000

I have created a table and a filter using the above data set, and added a filter for region.

I have added a calculation in table that shows sum(Value)/Sum(Total(Value)), when I applied filter of region that is if I select A in region filter then it also filtered the value of Sum(total(Value)).

How can I ignore Sum(Total(Value)) not to filtered on applying region filter?

[sunny_talwar]

Selection in Region or Sub-Region?

[#3]

Both

[sunny_talwar]

Would you be able to share a sample where this isn't working?

[#5]

Sorry, I will not be able to do so.

[sunny_talwar]

If I may ask, what is the reason for not being able to share? All I am asking is for you to load the dummy data you have shared above in a qvw file and let us know with selections what is the result you are expecting? If you are unable to do this bit to help me help you, then I am afraid I don't know what isn't working and it will be very difficult for me to understand what I am doing wrong.

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling

Uploading a Sample

[PrashantSangle]

Hi,

modify to Sunny expression.

You dont need to nulify both field just nulify subregion

Sum(Value)/Sum(Total <Region> {<Sub-Region = >} Value)

Regards

[sunny_talwar]

max‌ how does this matter? Its the denominator and would become 0 as soon as we select a region because numerator will be 0. Also the denominator is totaling by Region, again if we leave the Region in there, it should not matter.

I don't think this is the issue, the issue is something which we don't even know about

[PrashantSangle]

Hi,

stalwar1 Just try it and let me know it work or not as per requirement.

Regards

[sunny_talwar]

Hahahaha I guess I will wait for the OP to check. I am feeling lazy to create a sample and test it out

[#11]

Thanks Sunny, it worked.