topic Re: Fix some text box selections in QlikView

Fix some text box selections

danialier — Fri, 21 Feb 2014 18:04:44 GMT

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

Re: Fix some text box selections

Gysbert_Wassenaar — Fri, 21 Feb 2014 18:14:03 GMT

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.

Re: Fix some text box selections

rwunderlich — Fri, 21 Feb 2014 18:18:15 GMT

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

sum({1}Revenue)

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

-Rob

http://masterssummit.com

Re: Fix some text box selections

danialier — Fri, 21 Feb 2014 18:44:27 GMT

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

Re: Fix some text box selections

Gysbert_Wassenaar — Fri, 21 Feb 2014 18:56:02 GMT

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

Re: Fix some text box selections

danialier — Fri, 21 Feb 2014 18:58:39 GMT

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