Fix some text box selections

[danialier]

Hello

I have a QlikView with two tabs. First tab is a summary where I put the following info:

EMEA 10M$ (as a text box where the 10 number is the result of a formula)

AMS  15M$ (as a text box where the 15 number is the result of a formula)

APJ  8M$ (as a text box where the 8 number is the result of a formula)

In the second tab I have a list box with the three regions above and a graph with the revenue evolution.

What happens is that when I select whatever region in the second tab, the first tab gets updated and only showing the M$ for the region selected in the second tab. However what I want is to have the first tab ALWAYS showing the results of these three regions and then having the second tab in order to move from one region to another.

Please help.

thks,dani

[Gysbert_Wassenaar]

put {1} in the expressions to ignore all selections. For example Sum(Amount) would become Sum({1}Amount). If you only want to ignore selections in one field, e.g. Year, then add {<FieldNameHere=>}: e.g. Sum({<Year=>}Amount.

[rwunderlich]

Add the {1} Set expression into your formula on the first tab to ignore selections. For example:

sum({1}Revenue)

or

sum({1<Region={EMEA}>}Revenue)

-Rob

http://masterssummit.com

[danialier]

Thanks Gysbert.

I endeed want ignore the selections in the second tab but in the first tab I want to keep three text boxes (one per region) with the overall revenues. For instance this is what I have for EMEA region in the first tab:

  =num(sum({<[Product Line]={'Hardware'},Measure={'CI'},Category={'Lseries'},Month#={$(=max(Month#))},[Region detail]={'EMEA'}>}Units)

How can I fix that for EMEA and afterwards "play" with the second tab without updating the results in the first tab ?

thanks,

dani

[Gysbert_Wassenaar · Accepted solution]

  =num(sum({1<[Product Line]={'Hardware'},Measure={'CI'},Category={'Lseries'},Month#={$(=max({1}Month#))},[Region detail]={'EMEA'}>}Units))

[danialier]

Great !!!!!!!!!! many thanks !!!!!!!!!!!