SET ANALYSIS HELP

[sona_sa]

Team,

On selection of list box, Pivot Table Value should not change. Ignore all selection from list box by using of Set Analysis Expression.

Refer the attached QV File.

Thanks 

[Dalton_Ruer]

Imagine I want to sum up a field called SalesValue and want to override anything the user selected in a field called Location. I would simply do something like this. 

Sum( { <Location=>} SalesValue)

I do something similar in a hands on workshop I built and posted in Qlik Community here: https://community.qlik.com/t5/Documents/Hands-on-Set-Analysis-from-the-ground-up/ta-p/1799118

[sona_sa]

Hi Ruer,

I tried, Not working. You check in my QVW, I have tried in different - 2 way, But unsuccessful.

You can try in my QVW.

Thanks.