topic Re: Hide Selections in the Current Selections Box in QlikView

Hide Selections in the Current Selections Box

Thu, 05 Dec 2013 20:38:48 GMT

Hi All,

Hope someone can help with this... I have an case where I have created a chart using the expression:

Sum({$<Measure={'Trade Units'}>}Data) . Now, in a different Tab, let's call it Tab2, I have another Chart where the User selects the Measure to apply to the chart. My problem is that when the user selects a different Measure in Tab2, say Margin%, that Measure shows up in the Current Selections box in the first tab. I'm trying to prevent this from happening as I don't want to confuse the user.

I tried using Hide Prefix to Create [~Measure] and use that in the expression in the first tab,

Sum ({$<[~Measure]={'Trade Units'}>}Data)

However, this isn't very useful because there are other tabs where I do want the Measures to appear in the Current Selections box.

Does anyone know of a way to have Measure and [~Measure] exist within the same document but can be delineated across Tabs? I'm thinking that the best way is to remove the Measure fiels and leave only [~Measure] as a partial compromisse solution.

I know this is confusing and hope it makes some sense.

Cheers

John

Re: Hide Selections in the Current Selections Box

marthacano01 — Thu, 05 Dec 2013 21:25:24 GMT

Maybe you need to use Alternate States. I attached an example. I hope it helps you.

Re: Hide Selections in the Current Selections Box

rustyfishbones — Thu, 05 Dec 2013 21:34:53 GMT

Hi John,

I think using Alternate State will help you achieve this, Document Properties, General Tab, click on Alternate States

Click Add, type the name of your new Alternate State and click ok

Then in your Current Selection Box change the Alternate State to your new Alt1 state

Re: Hide Selections in the Current Selections Box

praveenak — Thu, 02 Apr 2015 16:32:14 GMT

Hi,

I think the only way is to use "Alternate States."

Please try it.

Will surely get back to u if some other way is possible.