values in a text box need to remain unchanged when a selection is made

[nkosinde13]

Hi All

I have a 2 text boxes, one is displaying Customer conversations published (volumes of 201 871) and the other one Actioned/ Unactioned /Inferred depending on a list box selection. The list box has actioned ,inferred and unactioned values. So what I need is for the Customer conversations published text box to remain unchanged when I make a selection so that the user can compare the actioning to the total always.

I've attached the example

Please assist on how I need to this. Thanks

[MindaugasBacius · Accepted solution]

I am not sure how do you calculate your expressions but this script ignores all the selections:

Sum ( {1 <Year = {2007, 2008}, Country = {‘USA’}> } Sales)

You will find this link useful as there are everything you need to know about Set analysis:

http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/SetAnalysis/set-an...