Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.